How to set up a split db for deployment (1 Viewer)

[wgma]

I have a split db application that I need to deploy to multiple machines. The trick is that the BE is not going to be on a server. Each machhine will be a stand alone environment.

How can I setup the links to the tables so that when I install on a machine I won't have to change the links?

For example, on my development machine the BE is on my F drive so the link from the FE to the BE is F:\projects\data\BE.accdb

So, of course, when I install this on a users machine I get an error because it can't find the BE.

What is the best way of doing this?

Thanks.

 

[boblarson]

Try this relinking code (courtesy of MVP Armen Stein):
http://www.jstreettech.com/files/JStreetAccessRelinker.zip

 

[wgma]

That looks good.

Now for the stupid question, I am not an Access developer so how do I use it?