Database Crash with Access 2007

[DavidN]

Please Help Me - Access 2007 problem

I have built a database with Access 2007, and intend on sharing the database amongst two users.

I am running Vista, and the two PC's or on a peer to peer network. Both with Vista.

I have split the database, and put separate copies of the front end on each of the PC's.

The backend of the database is on the public drive on my PC.

Access opens and functions correctly on both PC's with 1 User logged in.

However, if both users are logged in, my collegues PC crashes when it tries to open forms. This does not happen on my PC.

Does anyone have any ideas on what I need to change. Thanks in advance.

 

[DavidN]

Additional Info

I have checked the record locks on each form, and these are set to no locks.

Thanks
David

 

[DavidN]

More Information

One more bit of info.

My collegues PC does not crash, when it opens a form already in use, it locks, until my PC exits the form. I would like us both to be able to use the form.

 

[DavidN]

Still trying to figure this out, and it is very annoying

having searched the forums, I tried linking the form to a query, however, the exact same problem persists.

I cannot figure out for life of me, why I can go into the forms at anytime, regardless whether my collegue is in the forms, however, he can only enter the forms when I am not in the forms.

If anyone can help it would be much appreciated.

Thanks
David

 

[DavidN]

Please Help

Is anyone able to shed any light on this problem, or has a similar issue.

Regards
David