I've developed an access app(FE/BE) where FE will reside on end users m/c and BE on my m/c.

The prob is When i tried to run access from other m/c on the network,it gives an error message saying tht it couldn't find the BE database.I have to explicitly link the tables using Tools - database utilities - Link table manager only then it runs.I have to do this only for the first time i'm running the app,the next time app runs perfectly.

I tried to link tables using code in start up form but it also didn't work.

Any solution?