Secured database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Michael said:
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
Click to expand...

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
 
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 ?
 
Michael said:
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 ?
Click to expand...
Table links? The linked table manager under Tools/Database Utilities.
 
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.
 
Back
Top