network issues with b/e

[Jacko123]

I ave developed a database and split it to f/e and b/e and placed the b/e on the server and f/e on my colleagues and my own machines,my problem is both can access the database BUT neither of us can view the same form at the same time and get an error saying the form is locked by the user already viewing it,1st in egts the goodies so to speak, i have checked permissions etc and they all appear ok both on f/e and b/e, in both f/e and b/e i have set to no record locks also.Soooooooo what am i missing.?

 

[cmmrfrds]

The recordsets are being locked. You will need to check how this is happening. Look at your control flow in the app.

Are you using dynasets - they lock records.
What type of locks i.e. Pessimistic or Optimistic. Pessimistic locks when the record is retrieve and edited in a dynaset - Do not use unless for special reason.

 

[Jacko123]

yeah i'm using dynasets, would i be better with snapshots then.????

 

[cmmrfrds]

You will need to use dynasets if you are going to UPDATE, DELETE, or INSERT data. If you only need to look at data then the snapshot is okay.

Best to go over your control flow and make sure any given record is not locked in more than one place. Also, make sure you are using Optimistic locks as this places the lock just before the update. There are a number of things that can cause a record to be locked. One is not tabbing off a record that you are updating and then going to another form or if another user is trying to get the record it will be locked - make locks momentary. My guess is you probably have a pessimistic lock on the recordset.