Re: Copying access objects using .net

Hi Bob,

In order to copy a query or table from one MS access database to another, I
would request you to please go through the following site :
http://support.microsoft.com/default.aspx?scid=kb;en-us;298174

This site contains the code in order to accomplish the requirement and uses
the Data Access Objects (DAO) to import all objects from one microsoft
database into the current access database.

Hope tis helps.

Regards,
Mona [Grpaecity]

"Bob" <Bob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2A90397E-217F-4B23-91BC-28B7B1C0ED27@xxxxxxxxxxxxxxxx
> How do I program vb.net to copy a query or table from one MS Access
database
> to another?
>
> I'd like to accomplish what import does when it copies Access objects
> (primarily queries but some tables) from another database into the
database
> where the import action is selected---EXCEPT that I'd like to do this
> externally with a VB.net program.
> --
> Thanks, Bob


.

Relevant Pages

  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... boxes from the form header, events, code, etc and ran the form query source ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would be ...
    (microsoft.public.access.conversion)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: access 2003
    ... I removed the parameters from the form query source. ... synchronize combo boxes to the detail section or the parameter form query ... forms queries and the SQL because syntax of the SQL will change randomly. ... the Access 97 database, I wouldn't have thought any expressions would ...
    (microsoft.public.access.conversion)