473,382 Members | 1,387 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,382 software developers and data experts.

Relative Path Issues using Linked Tables in an MS Access DB

I have a MS Access Database that links to a number of tables in another database to support a number of queries. What do I need to do so that multiple users using a shortcut can use these queries without the absolute paths to the linked tables being an issue.

Thanks you.
Jul 8 '15 #1

✓ answered by zmbd

\\servername\pathtothefile
IS one method.. or you can use a relinking code... one version is located at:
http://allenbrowne.com/ser-13.html that you can easily modify to suit your needs.

Or our own:
Relinking ODBC Tables using VBA (Post #2 is worth a careful review)

You can also search this site for "relink backend" or refresh links etc... and a few dozen threads will popup, one of them will surely cover your situation.

If you need further help let us know.

2 6017
zmbd
5,501 Expert Mod 4TB
\\servername\pathtothefile
IS one method.. or you can use a relinking code... one version is located at:
http://allenbrowne.com/ser-13.html that you can easily modify to suit your needs.

Or our own:
Relinking ODBC Tables using VBA (Post #2 is worth a careful review)

You can also search this site for "relink backend" or refresh links etc... and a few dozen threads will popup, one of them will surely cover your situation.

If you need further help let us know.
Jul 8 '15 #2
zmbd
5,501 Expert Mod 4TB
Split related post to:
https://bytes.com/topic/access/answe...need-refreshed
Jan 29 '16 #3

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

Similar topics

1
by: jason | last post by:
Is it actually possible for a local access 2000 database to link to a remote database online via linked tables... I know www.aspfaq.com has spoken about possibliites (although not secure) for...
1
by: annie | last post by:
Hi all, I have recently ported my Access 2000 app to SQL Server, keeping the Access client as the front end using linked tables. I am also using triggers on my SQL tables to trap orphan...
2
by: Vern Shellman | last post by:
We've got a form in Access 97 SR-2 that works fine with local tables. The pertinent VB code populating a combo box looks like this: Private Function ShowMOFInfo() Dim db As Database Dim rec...
2
by: Sam DeRT | last post by:
Is there a way to hard code what a path to a linked table would be without going through the Linked Table Manager or a re-linking process? My issue is that I'm installing a database with linked...
1
by: Karen Hill | last post by:
I have a database which is split. The logic is in an MDE file, which connects to a MDB file via linked tables. Now, since the MDE file is installed, on one computer and the linked tables reside...
7
by: smd | last post by:
Hello and thanks for taking the time to read this. I've looked all over the web and newsgroups and can't find a solution to my problem. I've posted this question to the Access 2000 group as well -...
10
by: Robert | last post by:
How do you get an accurate count of the number of records returned from a query when using linked tables. I have an access 2003 database as a front end to another access 2003 database that...
4
by: xperre van wilrijk | last post by:
Hi, I have inherited an access userinterface that links to sql server tables through ODBC. The SQL server database contains data related to villages in my country and is populated by my...
1
by: James Armstrong | last post by:
Hey guys I am trying to link from excel to an access query I created. The query I created in Access uses linked sql tables via odbc. When using excel's import external data tool I am able to log in...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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: 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...
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.