Changing Back End Database Path

[Joe Williams]

I would like the user of my application to be able to call a windows dialog
box and select from from dfferent back end databases that may stored in
different places on the network. The access app would then relink the tables
to this new BE location.

I have tried the Relink Tables From Code example on the Access Web and other
sources but I cannot make it work. I believe I am missing references but the
code does not indicate what references I need. I try selecting DAO and a few
other references that I think it might be but I am unsuccessful. (I keep
getting various "undefined function" type errors no matter what I try.

Is there a better place to get code to help me do this, or can someone
explain how to achieve what I am trying to do?

THanks

- joe

 

[Douglas J. Steele]

If you're talking about the Access Web code at
http://www.mvps.org/access/tables/tbl0009.htm, a common mistake is to miss
the fact that it requires the code from
http://www.mvps.org/access/api/api0001.htm as well.

 

[Joe Williams]

I create a 2 blank databases, one FE, one BE and then I link them. In the FE
database I make a new module and paste in the code for the Relink Tables
From Code and the GetOpen FileDialog pages of the Access Web.

When I try to run the frefreshlinks function I get "User DEfined Type Not
Defined" or "Undefined Function" errors.

What am I doing wrong?

Thanks

- joe

 

[Allen Browne]

You probably omitted the reference to the DAO library.

From the code window, choose References on the Tools menu.
Check the box beside:
Microsoft DAO 3.6 Library.

More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html

 

[Joe Williams]

Allen,

Yes that works. Thanks!

You probably omitted the reference to the DAO library.

From the code window, choose References on the Tools menu.
Check the box beside:
Microsoft DAO 3.6 Library.

More info on references:
http://members.iinet.net.au/~allenbrowne/ser-38.html