473,385 Members | 1,555 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Need to use full path to linked tables

ollyb303
Hello,

I have a small problem that I hope someone can help with.

My Access 2000 database uses several tables and is split into BE and FE.

In the FE the tables are all linked to the BE but the file paths all seem to include the drive letter for the drive they are stored on. This is not a problem in our office as users all have the same drive mapped to the same drive letter, however the database is also to be used at another site where they have a different drive on a different server mapped to the same drive letter.

Is there a way to amend the file path to include the full path, ie:

\\Servername\Directory\Folder\Database.mdb

rather than:

S:\Folder\Database.mdb?

If not, would I have to update the links at the other office using LTM? I hope this is not the case as I don't have particular faith in users' abilities to do this unaided and I don't really want to have to go there to do it myself!

Hope someone can help.

Many thanks,

Olly
Dec 12 '07 #1
5 4902
Sorry to waste your time, I have figured this out for myself.

It was obvious really - I needed to navigate through the network file system when updating the links rather than doing it through local file system.

*kicks self*

Cheers.
Dec 12 '07 #2
NeoPa
32,556 Expert Mod 16PB
UNC path = \\ServerName\ShareName\Folder\Database.mdb

Is the ServerName and ShareName that the users in the other office use the same as that available to you (It should be I expect)? If so then you can fix it at your office so that it uses the full UNC path instead of using the drive letter format (Using LTM). This should then work in both places.
Dec 12 '07 #3
UNC path = \\ServerName\ShareName\Folder\Database.mdb

Is the ServerName and ShareName that the users in the other office use the same as that available to you (It should be I expect)? If so then you can fix it at your office so that it uses the full UNC path instead of using the drive letter format (Using LTM). This should then work in both places.
It is. It's fixed. I feel rather silly now. I was updating the links using LTM but navigating to the db via the local file system rather than through the network.

Thanks NeoPa.

Olly
Dec 12 '07 #4
NeoPa
32,556 Expert Mod 16PB
Not a problem Olly. I'm glad that helped.
Actually, though it seems obvious now it's been pointed out, it's not that obvious when you're doing it.
Dec 12 '07 #5
Not a problem Olly. I'm glad that helped.
Actually, though it seems obvious now it's been pointed out, it's not that obvious when you're doing it.
The joys of hindsight!
Dec 12 '07 #6

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

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
1
by: denis_bernicky | last post by:
I have been given a database on a CD to do some work on. The only problem is that when I open a form it tells me that the file path //server/database/mydb.mdb is not valid. Of course it isn't...
1
by: DT | last post by:
Hello all, I am experiencing quite a strange phenomenon with mu Access 2000 db. I am using linked tables to link to a backend Access 2000 mdb. I recently moved the file to a file path which has...
3
by: John Lewis | last post by:
I hope someone can help with this. I have a website using Access and ASP developed on my own PC (using PWS) and hosted on a commercial site. I decided that splitting the dbase up would be a...
7
by: Joe | last post by:
I am using Access 2003 and are linking to an Oracle 9i ODBC datasource (using Oracle ODBC drivers). After linking the tables in Access, I inspect the data contained in the linked tables. For...
1
by: Nick J | last post by:
Hi, I have my front and back end database (they are in development) on a network drive. Everytime I start the database up I get #Error? on DLookup objects and such. This is solved by 'updating'...
21
by: Johan Tibell | last post by:
I would be grateful if someone had a minute or two to review my hash table implementation. It's not yet commented but hopefully it's short and idiomatic enough to be readable. Some of the code...
7
by: franc sutherland | last post by:
Hi everyone, I am using Access 2003. I have a database with a table in it which is linked to an excel spreadsheet. When I install the database on someone else's system, the pathname to the...
3
by: macraig491 | last post by:
Hello, I have created several pivot tables using external data for which I had to set up a new data source. The data source is a Microsoft Access database. I'm encountering a problem when trying...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.