G
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
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