Secured database

[Michael]

I've set up 2 levels of access to a particular database, I've got the
security printout, all files are stored on a shared drive. (H), all these
files have been moved to a new drive (S) by IT services and I no longer have
access to the H drive. I've changed the pathways in the properties of the
icon, from H to S, but get an access error message because it can't find the
secured database on H. How do I amend the User & Administrator groups to
access S not H

Thanks

Mike

 

[Keith Wilby]

I've set up 2 levels of access to a particular database, I've got the
security printout, all files are stored on a shared drive. (H), all these
files have been moved to a new drive (S) by IT services and I no longer
have
access to the H drive. I've changed the pathways in the properties of the
icon, from H to S, but get an access error message because it can't find
the
secured database on H. How do I amend the User & Administrator groups to
access S not H

Thanks

Mike

There's more than one reference to your drive in the shortcut command line,
have you changed them all? Also, if there are linked tables then their
paths will also have to be updated, as will any drive references in code or
macros.

Regards,
Keith.
www.keithwilby.com

 

[Michael]

Thanks for the info, I had amended all the drive references, but had not
updated the links they were all still pointing to H. How do you update these
links ?

 

[Keith Wilby]

Thanks for the info, I had amended all the drive references, but had not
updated the links they were all still pointing to H. How do you update
these
links ?

Table links? The linked table manager under Tools/Database Utilities.

 

[Michael]

Thanks, I 'relinked' the tables which created duplicates (ie table1, table2,
etc), i then renamed the old linked tables, and finally renamed the duplicate
tables to the original names.