Making Access DB'es work in a 2-PC Network Environment (1 Viewer)

[arjon76]

After splitting an Access DB-file into two, how do I make it work for a 2-PC Network environment? Note: For security reasons, 1 PC will just contain the forms (or front-end), while the other PC will be made to contain both the forms and the tables (back-end). Also, the 2 PC's will be connected (most probably) by a Cross-over LAN cable and using LAN cards (if you have any other more efficient suggestion, pls. also tell me). THANX!

 

[shacket]

When you link to the tables in your back end, link to them through your computer's network name, not your hard drive. That way, the front end will find the back end no matter which computer it is on.