front end back end problem I think

[bb98765]

I have a live split db running which has recently run into a problem. When one user1 has a report open, user2 cant enter data into the table that the report is using. User2 gets a blank grey data input screen , apart from the form header. Similarly if User1 is entering data , and User2 tries to pull a report using the same table the message reads , could not lock table , currently in use by User1. Both Fes are on separate local machines
Ive had a check through my settings. On the advanced tab of Tools , Options default open mode is set to shared and default record locking is set to no locks.Plus open databases using record level locking is not on., both on FE and BE..

But, users 1 and 2 can pull the same reports simultaneously or enter data into the same table simultaneously but not one a report and the other enter data.

Anyone any ideas ?

 

[RuralGuy]

Try using queries of tables rather than the tables themselves.

HTH RuralGuy (RG for short) acXP winXP Pro
Please respond to this forum so all may benefit