Bill4tektips
Technical User
Does anyone know if it is possible to get tables to link together using relative links i.e. ../../ as opposed to absolute links i.e. C/My documents/.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Linked Tables problem 2
- Thread starter Bill4tektips
- Start date
- Status
-
1
- #2
This doesn't work. You can write code to check the links and if they are broken, change the "Connect" property to a value based on the CurrentProject.Path.
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
-
1
- #3
Do you mean just using FILE+GET EXTERNAL DATA + LINK TABLE....? If so, just type in the server and share name in the "File Path" box on the explorer browser window, i.e.
\\nss-01-hrt\databases\
then hit the LINK button and browse as usual to your db.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
\\nss-01-hrt\databases\
then hit the LINK button and browse as usual to your db.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question