473,326 Members | 2,127 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,326 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 4896
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...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.