Another user is editing this record

[Blackwidow]

Hi I was wondering if anyone could shed any light on this problem. I have a new database going live in two weeks. My problem is that I keep getting a message telling me that someone else is editing the record.. which is an impossibility as it is a stand-alone copy on my hard-drive at home! How is this possible? Will this problem be solved once I have this database on the sql server and the tables has been upsized to sql? Also this database is to be used by up to 100 people is this going to be a problem?

 

[Kempes]

I have come across this recently too but the reason was down to updating records that are still being referenced in another part of the database.

EG,

If you have a form open with a field called [Field1], if you open another form relating to the same field without closing the first form, change the Value for that record then exit both forms, this message will appear on closing the original form you opened.

 

[Blackwidow]

Possibily!

Quite possibily that is my problem!

Sometimes its so Obvious I miss it completely!