By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Code to Copy all objects in one db to another?

P: n/a
Jim
Hi All.

I'm working with a group of remote users and need to send them updated
tables, queries, forms and reports on a weekly basis. What I do is
create a separate little database with all the new items in it, and
then do an autoexec macro that does the CopyObject action on each one
of them, but to do this, I have to edit the macro a lot and if I have
30 objects in the database that need copying, I have to have the
CopyObject action in the macro 30 times.

Is there a way to tell Access to copy ALL Tables from database A to B,
copy all Queries from database A to B, copy all forms from database A
to B, etc?

Jul 25 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Jim wrote:
Hi All.

I'm working with a group of remote users and need to send them updated
tables, queries, forms and reports on a weekly basis. What I do is
create a separate little database with all the new items in it, and
then do an autoexec macro that does the CopyObject action on each one
of them, but to do this, I have to edit the macro a lot and if I have
30 objects in the database that need copying, I have to have the
CopyObject action in the macro 30 times.

Is there a way to tell Access to copy ALL Tables from database A to B,
copy all Queries from database A to B, copy all forms from database A
to B, etc?
You could try
http://www.ffdba.com/downloads/Save_...ts_As_Text.htm
(it also creates a new copy of the db with everything rebuilt).

Jul 25 '06 #2

P: n/a
Hi JIm,

Why not send the whole mdb-file? That is "what you had" plus the
increments.

HBInc.
Jim wrote:
Hi All.

I'm working with a group of remote users and need to send them updated
tables, queries, forms and reports on a weekly basis. What I do is
create a separate little database with all the new items in it, and
then do an autoexec macro that does the CopyObject action on each one
of them, but to do this, I have to edit the macro a lot and if I have
30 objects in the database that need copying, I have to have the
CopyObject action in the macro 30 times.

Is there a way to tell Access to copy ALL Tables from database A to B,
copy all Queries from database A to B, copy all forms from database A
to B, etc?
Jul 25 '06 #3

P: n/a
Buy the Enterprise edition of Office and replicate/sync the databases.

Jul 26 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.