Front End and Back End

[JAVIRAFY]

I am having a trouble with a multiuser DB. I have split it using the Splitter Wizard and have put a copy of my FE to a second computer and relinking its tables. When I opening the bound form in computer 1, computer 2 can not open that form and sometimes computers lock and had to restart the machines. But if I open that form in computer 2 first and then the same form in computer 1 , it works fine. I have set full sharing to computer 1. I am using Access 2007 and Windows VISTA.

Both have FE, the BE is located in a shared folder with full permissions in C: in computer 1, the FE of computer 1 is in that same folder. Both computers are connected via a Cat5e Cable.

FE in computer1 table links to c:\databaseBE and computer 2 links to computer1_IP_Address\c:/databaseBE


Can anyone help me please!!!

I'd appreciate it a lot

Thank you!!

 

[orna]

Check:
Tools -> Options -> Advance -> Default Open Mode *Shared*

 

[JAVIRAFY]

It's set shared mode