change link address with vba

[Guest]

Using Access 2003 on XP. I have created a frontend/backend application that
will likely be installed on a network. The user will save the backend to a
network location (which I will not know the address of beforehand). I would
like a way to programmatically ask the user when they open the frontend where
the backend is located, and update the linked tables accordingly. A windows
explorer type dialog box would be ideal, simply navigating to the backend.
Is this possible? Thanks in advance.

Adam Milligan

 

[Allen Browne]

Download Microsoft's sample database - solutions.mdb - from:
http://support.microsoft.com/kb/248674

There's a module in the database that does what you want. Checks the back
end on start up. If it's not present, it pops up the FileOpen dialog for the
user to locate it.

 

[Peter Hibbs]

Adam.

Or have a look at -

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

Peter Hibbs.

 

[Douglas J. Steele]

And just to be different, there's
http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web". <g>

 

[Guest]

Or, what I do is hold the location info in an INI file held in the same
directory as the application, and on opening up the firs form, reading the
INI file and attempt a reconnection at that point.

This means the user dosn't have to know where the data is located, and if
you decide to upsize to SQL server, you can enter the ODBC connection string
instead

HTH
Chris

 

[Guest]

I found Doug's solution fit my needs the best. Thanks!