473,769 Members | 7,923 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

14 New Member
Hello,

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.

Help!!!!
Sep 7 '08 #1
1 2515
ADezii
8,834 Recognized Expert Expert
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\1 033\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

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

Similar topics

3
24035
by: Random Person | last post by:
Does anyone know how to use VBA to relink tables between two MS Access databases? We have two databases, one with VBA code and the other with data tables. The tables are referenced by linked tables in the database where the code resides. If we move the database with the data tables to a new directory, the links are no longer valid. I tried to update the links by changing the Connect property and refreshing: Set td = db.TableDefs(0)...
3
2121
by: Bonj | last post by:
I have a service which is a Windows Service, but it is running under a User account - I enter my own credentials on installing. It can access network files by specifying the full UNC path, i.e. \\server\share, but it can't use mapped drive letters. Is there anyway I can modify it so that it can? Thanks
5
4476
by: Nirosh | last post by:
Hi All, Can any one suggest me a best way to do this .. I have a thrid party tool "EXE" that we need to use with our web service to manipulate some complex XML files, which reside in a seperate files server. we have mapped the fodler to a different folder and need to allow the EXE to process on the mapped drive. When I trigger the EXE via web service the EXE get the permission of the launching user (mean ASP.NET user) resulting a...
1
5071
by: Byron | last post by:
Hi, I have(had) an old Win2k Server server with about 30 web site databases (SQL 2000) that just went under due to hardware problems. Thankfully, I have backups of all the databases plus the MDF and LDF files from the hard drive. I want to move all of these sites and their data to a newer server (Win2003) running SQL2000.
12
4753
by: lesperancer | last post by:
I've got two MDBs, that due to size, security, etc, need to be kept separate quotation configurator (there will be more of these in the future) so within quotation.mdb, I linked all the tables that configurator.mdb uses I created a reference to configurator.mdbm using full path name I open a 'configurator' form, and away to work I go
5
1578
by: Marc | last post by:
I am trying to run a web service that has pre-compiled dll's that reference dll's that are on a mapped drive. The web service can not load because it does not see that mapped drive and returns an error of "Can not file specified module". Mapped drive is added to path. Thanks, Marc
4
11739
by: sajid_yusuf | last post by:
Hi I am trying to develop a Windows service in VB.NET which has timer enabled and keeps checking a folder (or group of folders) for any new file or changed files. As soon as it detects any new file or changes (to files or folders) then it copies the files (and any new folders) to a folder in the mapped network drive. So far I have been successful in developing and deploying the service which works on my local machine with two drives...
3
2478
by: najimou | last post by:
Hi everyone I will be having a split database, running on 2 computers via mapped drive. computer "A" will have one front end and the back end located in c: \mydatabse 2 tables have links to many images stored as c:\mydatabse\images \images.jpg so computer A has no problem accessing the picture
1
2287
by: thanawala27 | last post by:
Hi, I have mapped a server to my computer (called it H drive). all my perl scripts run on the server. Now, i would like to copy a file from my local hard disk (C drive) to this server. As my scripts are running on the server, so while copying the file, the server is not able to recognize the location of the C drive (which is my local computer) So, how do I make the server recognize my local computer and hence copy the file to the...
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10049
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9997
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9865
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6675
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3965
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3565
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2815
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.