record locking not behaving as expected

[Bob Wickham]

I have split my database and set the record locking to "Edited Record" -
Pessimistic, which is supposed to prevent a user from editing the same
record that another user is editing. Its also suppose to display a symbol on
the form.
But the forms are behaving like I have record locking set to "All records" -
Optimistic, with the resulting message asking me if I want to Discard
Changes, Copy To Clipboard etc

Any ideas?

Bob

 

[Jeff Boyce]

Bob

Where is the back-end data? Do you have it stored in a SQL-Server database?
If so, a somewhat obscure issue I ran into requires the addition of a SQL
column of datatype TimeStamp (note - this is NOT a date/time datatype) if
the table held ANY "checkbox"-type fields. This allowed SQL-Server to
realize that you were the one who opened that record for editing...

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[bajintas]

Bob

Where is the back-end data? Do you have it stored in a SQL-Server database?
If so, a somewhat obscure issue I ran into requires the addition of a SQL
column of datatype TimeStamp (note - this is NOT a date/time datatype) if
the table held ANY "checkbox"-type fields. This allowed SQL-Server to
realize that you were the one who opened that record for editing...

Good luck!

--
Regards

Jeff Boycewww.InformationFutures.net

Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/

The back end is in an Access database split using the Database
Splitter tool.
Both fe and be are on the same server but in different folders

 

[Jeff Boyce]

Bob

You might want to take a look at the tablesdbdesign newsgroup...

There's a consensus of opinion that having multiple users sharing a single
front-end on a server risks corruption. The alternative is to place
individual copies of the front-end on each user's PC, each/all linked to the
single back-end.

I'm not sure what else might be causing the symptoms you describe. Have you
tried searching on-line?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Bob]

Thanks Jeff,

My database front-end is on each users pc, all connected to a single
back-end.
I've tried looking on-line but no success, but considering some of the
other weird things that happen on the larger network where this database
is stored, maybe the problem is unique to my database.

Thanks for your time.

Bob