Good morning all:
I have an Access database that I recently made some improvements to and committed back to the network drive in my office for everyone to use. One of those improvements was to split it into a front end and back end.
It works fine on most computers, but there are two or three that, when my co-workers try to open it, Access tells them that the path to the back end file is invalid.
I tried compacting and repairing both the front and back ends, putting them both in the same folder, deleting and copying them back to their respective locations (all pretty desperate moves, I know) - but no results.
Someone posted a similar problem earlier in the year, but no one responded. So here is your second chance to respond, experts!
Thanks!
Pat
6  5008 
Have you tried relinking the tables?
NeoPa 32,556
Expert Mod 16PB
Let me know if the info in Need to use full path to linked tables helps you to resolve this.
I'm fairly sure that the problem is related to the path not being "valid" on some machines but valid on others.
Let me know if the info in Need to use full path to linked tables helps you to resolve this.
I'm fairly sure that the problem is related to the path not being "valid" on some machines but valid on others.
Well, one of our network people took a look at the situation and did something that corrected the problem before I could try anything in your link. I still don't know yet what her solution was, but I will find out tomorrow and keep everyone posted!
NeoPa 32,556
Expert Mod 16PB
If it was a network person I guess they probably made the share available to all the other PCs on the same drive letter. Let us know anyway.
If it was a network person I guess they probably made the share available to all the other PCs on the same drive letter. Let us know anyway.
In a manner of speaking, I think that's correct. I just got off the phone with them. What they had me do was open up the development copy of the front end on my computer, right click on one of the linked table, and open up Linked Table Manager. I then selected all the tables, checkmarked "Always prompt for new location", and hit OK.
In the resulting dialog box they had me type in some obscure path that I wasn't aware of. Apparently, now whenever I commit a new version of my front end to the network drive, it will always point to the proper place.
Anyhow, it fixed the problem! Thanks so much for responding...
Pat
NeoPa 32,556
Expert Mod 16PB
No problem Pat.
Actually, from your last post it sounds as if she knew about how Access works too and had you use a UNC path (I would guess) to the share rather than using a drive letter at all.
That's cool - That's exactly what I would have suggested 8-)
Sign in to post your reply or Sign up for a free account.
Similar topics
by: TimS |
last post by:
I am getting a baffling File not found error (0x800A0035).
I am writing asp on a windows 2000 server. I build a path and filename from
several fields in a jet database using SQL commands, like...
|
by: David Webb |
last post by:
The problem started when the Working Folder for a project was somehow set to
the folder of another project. I set the correct working folder in VSS and
deleted the .vbproj files that had been...
|
by: karunakar |
last post by:
Hi All
I am not able to read the class name I want read the particular class name
string path =
System.Configuration.ConfigurationSettings.AppSettings;
string className = path + ".User";...
|
by: shimonsim |
last post by:
Hi,
I need to upload pictures from client machine and I am using HtmlInputFile
control I set validator to make sure that file has correct expention but if
one of the files has incorrect extention...
|
by: John Phelan-Cummings |
last post by:
I have a front-end application called, “inbusiness.mdb” and three
back-ends
databases called,
“inbusinessClient_be.mdb”, “inbusinessFund_be.mdb”, and,
“inbusiness_be”. I
created three back-ends...
|
by: DH |
last post by:
Hi,
I'm trying to strip the html and other useless junk from a html page..
Id like to create something like an automated text editor, where it
takes the keywords from a txt file and removes them...
|
by: Arengin |
last post by:
HI everyone,
I am new with Xerces-C but I managed to get a DOMTree runing and to extracte the data to the screen. However I need to write the Tree back to a file.... and this is where I am stuck. ...
|
by: ADezii |
last post by:
Many times when writing VBA code, we find the need to work with Files in one form or another. Whatever the process may be, we need to be sure that a File is present in a specified location. One...
|
by: LordHog |
last post by:
Hello,
How would I go about finding the default handler, let's say a text
file (*.txt), then launch the default handler with the file as an
argument? I had found how to launch an external...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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,...
|
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...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
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...
| |
