Database hang when a form is open

[Syphonics via AccessMonster.com]

My access database is split into 2 copies of FE. One on my colleage
workstation WinXp and one on my workstation Win Vista. The BE is in the
server running win server 2008.

Whenever my colleage runs the database and have at least a form open, and
after that I try to open my FE database my access program will hang. It will
resume back once my colleage closes all the forms.
Does it have to do with my forms? Or some forms settings?

Now only 1 workstation can run the database. Please do help me.

Thanks.

 

[Golfinray]

Check several things:
1. The BE file AND the folder it resides in requires read/write/edit/delete
rights for all users.
2. The FE needs to be on each users computer.
3. The database needs to be compiled to work properly as a split database.
Go into the vba editor, click on debug\compile. If it does not compile, you
have code problems somewhere.
Get these issues resolved and if you still have issues, compact and repair
the database and try again.

 

[Syphonics via AccessMonster.com]

How do i know if the program can be complie? , I hit the complie button
nothing happens.

Check several things:
1. The BE file AND the folder it resides in requires read/write/edit/delete
rights for all users.
2. The FE needs to be on each users computer.
3. The database needs to be compiled to work properly as a split database.
Go into the vba editor, click on debug\compile. If it does not compile, you
have code problems somewhere.
Get these issues resolved and if you still have issues, compact and repair
the database and try again.

My access database is split into 2 copies of FE. One on my colleage
workstation WinXp and one on my workstation Win Vista. The BE is in the

[quoted text clipped - 8 lines]

Thanks.