Changing Back End Database Path

  • Thread starter Thread starter Joe Williams
  • Start date Start date
J

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
 
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
 
Back
Top