Default BE location ?

[Isis]

Is there a way to have a DB front end default to looking for the back end
tables in the current folder ? How do people normally manage this type of
thing - I am developing in one place for use in another.

Thanks

 

[Ken Snell \(MVP\)]

There is not a "default" setting in ACCESS. Instead, you use VBA code to
relink the front end to the back end. See this page for information:
http://www.mvps.org/access/tables/tbl0009.htm

You can set up your front end file so that this code runs when the front end
file is opened.

 

[bhicks11 via AccessMonster.com]

Tell you what I do - I make the same folder everywhere I put it. It will be
fine if you do.

Bonnie

http://www.dataplus-svc.com