Rename Secured .mdb and .mdw 1

[mmusick]

Will renaming a .mdb and the corresponding .mdw cause problems? I have multiple users accessing a secured database using a shortcut copied to their desktop. I want to replace both the .mdb and .mdw with new and not change the shortcut. Is there a way to accomplish this?

 

[lupins46]

The shortcut will refer to specific files by name. If you change the names of the files the shortcuts won't work.

 

[lupins46]

What is the real objective her?

 

[mmusick]

The objective is to save the old (in production) version of both the .mdb and .mdw by renaming them. Then rename the new (tested) version of the .mdb and .mdw by renaming them to what the production version was called. Leave the shortcuts alone.

Thanks

 

[lupins46]

I can't see any problem with that PROVIDED you have set up the users and groups in EXACTLY the same way as they were set up in the production workgroup - I mean the same username and PID values.