By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,726 Members | 1,091 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,726 IT Pros & Developers. It's quick & easy.

relink the master copy of the database to the mapped drive.

P: 14

I am following steps to implement security on access 2003 through distribution:

I have split the database and I am trying to distribute it:

I have copied the back end file and Security.mdw to a shared network directory.
Map each user's PC to the shared network directory.

However, I am stuck at this step which is to use the Linked Table Manager to relink the master copy of the database to the mapped drive.

However, I am not sure what master copy? is this the front end copy? When I tried to open the original database i.e. the front end (not the shortcut) I get a message that I don't have permission to open it. I open the shortcut and tried to relink then copy the shortcut on the network. However, when I tried to open on a pc that is mapped to the shared network directory, it could not find the file.

Once I get through the "relinking" step, the next step is to copy the relinked database to each user's PC. However, I stuck and need help because I don't know how to relink using the Linked Table Manager. And not sure what copy to relink.

Sep 7 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 5K+
P: 8,692
Try the following:
  1. Refresh your current Links
    • Tools
    • Database Utilities
    • Linked Table Manager
    • Check Always prompt for new location
    • Click on Select All
    • OK
    • Select the location of the Back End Database on the Shared Drive
    • Open
    • All Links are now refreshed and point to the new location
  2. You must Join the newly created Workgroup Information File also on the Shared Drive
    • Open the Workgroup Administrator typically located in C:\Program Files\Microsoft Office\Office\1033\Wrkgadm.exe
    • Click the Join Button
    • Browse to Security.mdw on the Shared Network Drive
    • Open
    • Your Database will now inherit the Security defined in Security.mdw
  3. Copy the Front End to the other PCs (as long as those other PCs have identical Mappings). Should the Mappings be different for a PC, you must run the procedures for Re-Linking and Joining a Workgroup on individual Front End PCs..
  4. Good Luck, and let us know how you make out.
Sep 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.