Cannot find Backend in split database 1

[hefly]

I have Access 2007. I split the DB on my machine and I have distributed the front end.

The frontend opens to the path to the backend on my machine, but the distributed Frontends can't locate the backend from the other user's computer. The backend is on a common server.

How do I allow the front end on the users' machines to browse for the back end?

Thanks.

Hefly

 

[hefly]

Hey!!! I found it accidentally. Right click on a linked table and open "Liked Table Manager." Choose the tables, refresh the links. Linked Table Manager does it all for you.

Thanks!

Hefly

 

[MajP]

If interested I have the code that does the following
1)Automatically check make sure all tables are linked
2)If not presents a file browser to search for backend
3)Relinks all tables based on selected file.

Basically automates the steps of the linked table manager so that you can hide this from the user. The code is pretty advanced, but works well.

 

[hefly]

Absolutely! That would be great MajP.

Thank you!!

Hefly

 

[MajP]

Here is the code.

http://www.4shared.com/document/M6sA42SP/RelinkUtilities.html

There is a hidden form that I open when the db opens. The code is in the form to call the code to do the relinking. There is a module with all of the relinking code and another just for a common dialog (I like the API version).

Some of this code is mine and some is from other sources. I have made it a little more complex, because I allow the user to click a button to link to a network backend or select a local replica back end.

This will probably take a while to digest.

 

[hefly]

Thank you MajP!
The form stops on Debug. I guess it needs some linked tables to run?

Hefly

 

[MajP]

Yes, you will have to modify some of the code on the form. It was specific to the app. Make a dummy backend and link to it. Then move the back end and see if you get a file browser to go find it.

 

[MajP]

In the form code
change
MsgBox Err.Number & ": " & Error.Description
to
MsgBox Err.Number & ": " & Err.Description

In the relink module I call a standard error checker which does not exist. Make your own message. After that it seems to work fine.

 

[hefly]

Thank you again MajP for the explanation!

Hefly