Relative/Absolute path...

[Guest]

I have used three linked tables in my front end form. The problem is that the
path of the tables are all absolute and I want to turn them into relative
links so that whenever I place my database and form in some other directory,
the form works there as well.

Any idea?

Thanks.
--Talha

 

[Allen Browne]

Access does not support relative paths in the Connect property of a
TableDef, but you can reassign them in your database startup code.

This example assumes the linked tables are in the same folder as the front
end:
http://allenbrowne.com/ser-13.html
You could adapt that to suit other folders below that.

 

[Guest]

Thanks.