Creating a "local" copy of a linked database

[Guest]

I have a database with a front-end/back-end configuration. Several users have
front-end copies of the forms and queries - these are all linked to a single
database-be.mdb file. There is also security on these front-ends in that
users have to log-in to access the DB. Some have read-only privs; some can
append; some have full access.

The DB owner wants me to create a read-only copy of the database he can put
on a CD and give to someone else.

I initially made a copy of the front-end, and deleted all the linked tables.
I then tried importing each of the tables in the back-end DB, thinking I
would now have a local copy of the data. Well, that didn't seem to work. The
tables remained linked.

So how can I get all the back-end data into a "local" copy of the database?

Also, this will be a recurring process - the customer will be wanting an
updated, read-only copy of his database on a regular basis. Automating this
process would be a definite advantage.

Thanks for any assistance you can provide.

Art Goldman

 

[John Vinson]

The DB owner wants me to create a read-only copy of the database he can put
on a CD and give to someone else.

I'd suggest distributing it as a frontend-backend pair; just be sure
you have relinking code in the frontend's startup form.

John W. Vinson[MVP]