Copying access objects using .net

[Bob]

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

[Mona]

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...b;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" <Bo*@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...

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

[Bob]

Mona, thank you for your reply.

I have 11 users, each in a different location. I have a vb.net app which is
used by each user to modify his/her respective Access data base.

Each time a user installs the latest version/release of the app, he/she gets
an updated vb.net program, an updated xml report file, and an updated test
database.

The test database contains new queries that are used by new reports.

My problem is to get these new queries into the respective production
databases by having the user click on a button to do so.

So I'm relegated to doing this using vb.net and not by using Access .

Any suggestions?

--
Thanks, Bob
"Mona" wrote:

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...b;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" <Bo*@discussions.microsoft.com> wrote in message
news:2A**********************************@microsof t.com...

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