Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: In need of an Access expert!

29 Jan 2012   #1

Windows 7 64x
In need of an Access expert!

Hi chaps, I have a customer who has asked me to solve a problem with his Access database. The employee who authored it is long gone and the 'redesign' of his company relies on this issue being solved.

He has this moderately complicated database that he wants to keep on a server and have network computers connect to it using a mapped drive. This would be fine if the DB was a single file but instead its one DB with many other linked DB files (linked tables) attached to it. I'm sure I don't need to tell you that this causes the remote computer to look for the linked tables on ITS OWN hdd and not the servers.

So is there a way to work it so he can do what he wants or do I have to find a way of incorporating all those linked tables into the main database file?

Hope someone can help!

My System SpecsSystem Spec

30 Jan 2012   #2

Systems 1 and 2: Windows 7 Enterprise x64, Win 8 Developer

There are reasons why you would want to link to other external tables, such as SQL, etc. But if all these external tables are simply other MS Access database files, I don't see why you couldn't combine them into one file. It makes sense to have a database on a server, so it will be backed up and accessible to more than one user. I don't see why the links are looking to an individuals hard drive, rather than the mapped drive. You need to examine the code and make sure it accounts for the mapping, and the mapping is consistent. I'm assuming this worked at one time? If so, has your mapping changed? Did you make any changes that affected the dB?
My System SpecsSystem Spec
30 Jan 2012   #3

Windows 7 64x

Ok, no biggy. I just put the main DB and the collection of linked tables in their own folders and shared them on the network. Then I replaced all the filepath's within the' linked table manager' with the new network path. it didn't work before because all the files were on one local drive before the links were all local too.
Simple now I know!

I do have one other issue though. Because the database will now be available to many people instead of one is there a way that I can lock access to it if another user already has it open?
My System SpecsSystem Spec

30 Jan 2012   #4

Systems 1 and 2: Windows 7 Enterprise x64, Win 8 Developer

Yes, but you have to do that from within Access rather than the operating system.

Keep in mind you want to lock the particular record and not the whole database.
My System SpecsSystem Spec
31 Jan 2012   #5

Windows 7 64x

Ok, thanks loads for your help!
My System SpecsSystem Spec

 In need of an Access expert!

Thread Tools

Similar help and support threads for2: In need of an Access expert!
Thread Forum
How do I become an expert in Windows? General Discussion
Think i need some expert help with this one im stumped PC Custom Builds and Overclocking
Please guy, I'm beg for someone expert in computer PLEASE help me .. Drivers
Need Defraqgler expert Performance & Maintenance
Need an XP activation expert! Chillout Room
Anyone here an expert when it comes to using TrueCrypt? Chillout Room

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 08:48 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33