Linked db in current folder

[rafal444]

How to have database withlinked tables to another the database in the current folder?

I want to split my database to two seperate files, so I can update the user with interface changes only, without overwriting his data... Both databases would always exist in the same folder. I do not want to have path hardcoded, but rather have it as ".\"...

Other suggestions are welcome..

 

[Pampers]

What is the problem with a 'hardcoded" path to the backend (I dont think you can use something like a virtual directory)? If you want to change the path, you can use the Linked Table Manager

Pampers
Just back from holiday...
that may it explain it.

 

[rafal444]

I do not know what pathe the customer is using...

 

[Pampers]

That doesn't matter I think. The two stay connected, either if you are sharing the front end over a network, or putting/copying the front ends on the users computers. The front end stays linked with the back end. Only if you put the back end somewhere else, then you have to tell the front end that the be has moved...


Pampers
Just back from holiday...
that may it explain it.

 

[rafal444]

I understand, It is just my client is using x:\...\accesdb while I am using c:\my documents.... Everytime I give him new front-end, he needs to change links. He does not like it...

Both databases are in the same directory. Is there a way to specify relative path or have some code to run when user starts application?

 

[PHV]

Have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Pampers]

maybe this can help too:

thread702-1271729

Pampers
Just back from holiday...
that may it explain it.