We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
MS Access problem
Marty999
Posts: 728 Forumite
in Techie Stuff
I am not used to using Access, but I am trying to help one of our users open an Access file which appears to have a separate database linked to it. I have this file too, but Access thinks it is saved on a mapped drive. I have tried creating a mapped drive both on our server and on the local PC, but the path name is not the same and therefore I am not able to open it successfully. I have tried editing the path name after using the subst command but this does not work either.
Any ideas please?
Any ideas please?
0
Comments
-
Unless you know which specific network server the file it needs is on, its pointless mapping anything. You need to work that out first or what the purpose of the file is.0
-
Is it using linked tables? If so open the linked table manager and re-map the tables.I am not used to using Access, but I am trying to help one of our users open an Access file which appears to have a separate database linked to it. I have this file too, but Access thinks it is saved on a mapped drive. I have tried creating a mapped drive both on our server and on the local PC, but the path name is not the same and therefore I am not able to open it successfully. I have tried editing the path name after using the subst command but this does not work either.
Any ideas please?Since when has the world of computer software design been about what people want? This is a simple question of evolution. The day is quickly coming when every knee will bow down to a silicon fist, and you will all beg your binary gods for mercy.0 -
I have just sussed the problem out - the file path was referring to a T: drive that did not exist on our system but I re-assigned the drive letter T to a USB flash drive, copied the file and folder to the flash drive, and then it worked. Thanks for your input guys. Marty.0
-
You should always reference the absolute network address and not the mapped address (i.e., [URL="file://\\network\directory\file.mdb"]\\network\directory\file.mdb[/URL] not T:\directory\file.mdb)
That way, if the drive mappings are lost, there is no problem.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards