Question Help with splitting database...

[browninaz]

O.K. guys,

All of you Access whizzes have always pulled through in the past helping me to build this hot mess of a database, and thank you all so much! Now that I have the file ready to rock, I need to know what I should know about splitting it.

The database is going to be used on a network with four nodes, but before I set this thing up at work, I have split a copy of the database on my home network, and the splitting part was easy. But now when I open the file on my laptop, I get the error message 'Could not find file '\C:\Users\Documents\CompanyFile_be.accdb'. :banghead:

I created a shortcut of the front end and placed that on my laptop as well as placing an actual copy of the front end of the file on my laptop, and I get the error message with either action. Do I split the database and create a shortcut to place on everyones desktop, or do I make an actual copy of front end of the file and distribute that? Lastly, after I do whatevers right, how can I get the remote location to find the file, and can it be done without coding?

Anyways, thats my dilemma...

 

[John Big Booty]

Sound's like you need to re-link the tables to the front end. The article here should help you out.

 

[browninaz]

Thank you once again, John. That worked like a top!