Linked Tables

[trebor3900]

I have a database with the tables linked from another database. The problem is that i need to copy the database to and from another machine in order to work on it. As this involves putting it in a different location each time, i have to relink the tables.
Is there a way to link the tables reletively so that as long as they are in the same Directory they will be linked?

 

[FoFa]

If you use a DNS entry (called the same on both machines) that usually works. Just use an ODBC link instead of a direct link.
You could also get the code to relink the tables (VBA) and change it to do the linking via a macro or form.

 

[ReAn]

I think you mean a DSN (Data Source Name) not a DNS (Domain Name System)

DSN = ODBC databases
DNS = www.somename.com

 

[FoFa]

Yea, What ReAn said!

 

[trebor3900]

Dsn

Thanks for that guys. Haven't a clue what DSN is but it gives me another avenue to explore.

 

[FoFa]

DSN is a setup that you connect to (or link to) that specifies what it is.
So if you were going to link to SQL server (as an example, could be Acess, could even be a text file) you usually go to control panel, and there or in admin tool there is a Data Sources tool to setup a DSN. How that is done depends on what you are trying to connect to.

 

[still_rookie]

this probably may not help much, but why don't you just burn the whole directry onto a CD/RW or something ?

 

[ghudson]

this probably may not help much, but why don't you just burn the whole directry onto a CD/RW or something ?

That does not help if the user places the db files in a different location from the original source.

The command will call the Link Table Manager...

DoCmd.RunCommand acCmdLinkTables

There is code floating around that will relink your tables. There are different variations and the process is involved. Depending on your knowledge of VBA and how easy it is you want to make it for the end user will vary on how hard you have to work to get the code working for your application.