Relink Tables

  • Thread starter Thread starter Paul Ilacqua
  • Start date Start date
P

Paul Ilacqua

I have several (15) secured access Databases with several linked tables
each.
My company need to move data and change drive letter of the data and on
some front ends. I know when you remap a linked table you have to redo
security on those tables on the front end and back end databases.
How can I "Copy" my current security scheme and just reapply it but with
newly linked tables. My users are several hundred and do not remember what
group has access to what tables and at what level. Is there a product I can
look at, or I'm proficient @ VB, is there code I can rwrite to accomplish
this.
Thanks
PS I'm using Access 97 80% Access 2002 20% and have 2 workgroup files.
Paul
 
Hi Paul,

Paul Ilacqua said:
I have several (15) secured access Databases with several linked tables
each.
My company need to move data and change drive letter of the data and on
some front ends. I know when you remap a linked table you have to redo
security on those tables on the front end and back end databases.
Click to expand...

The permissions are stored in the mdb. Moving them should not require you
to redo the security.

You should be able to use the Linked Table Manager (in the Tools menu) to
point the links to the new location of the backend.

There is also code in the Solutions database that ships with Access that you
can use to relink tables.
 
Back
Top