"Row level locking will be ignored" when I password-protect a split database? (1 Viewer)

Oimoi

Registered User.
Local time
Today, 09:08
Joined
Jul 17, 2011
Messages
42
"Row level locking will be ignored" when I password-protect a split database?

Afternoon, everyone.

So I've run into a bit of trouble while encrypting my front and back-ends, and I'd appreciate any help at all!

I'm using Access 2010 and just recently split my database. I set a password for my back-end, then my front-end (and re-linking the back-end tables in the process). Each time, I got the following message: "Encrypting with a block cipher is incompatible with row level locking. Row level locking will be ignored."

If possible, how do I go about having the passwords WITH row level locking enabled?

Many thanks in advance. =)
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 14:08
Joined
Sep 12, 2006
Messages
15,613
Re: "Row level locking will be ignored" when I password-protect a split database?

do you really need the locking?

what are you doing that needs to use a pessimistic locking strategy?
 

Oimoi

Registered User.
Local time
Today, 09:08
Joined
Jul 17, 2011
Messages
42
Re: "Row level locking will be ignored" when I password-protect a split database?

Appreciate the response.

Several users will be using it at the same time, so I have the Record Locks property set to Edited Record for some of the forms. Unless - that's still in tact, and the statement "row level locking will be ignored" refers to something else? I have very little background in Access, so I apologize if I misunderstood my own problem. D:
 

boblarson

Smeghead
Local time
Today, 07:08
Joined
Jan 12, 2001
Messages
32,059
Re: "Row level locking will be ignored" when I password-protect a split database?

Row level locking is desired in a multi-user database because otherwise Access will lock pages of data which can affect users not even wanting the record that is being updated.
 

Oimoi

Registered User.
Local time
Today, 09:08
Joined
Jul 17, 2011
Messages
42
Re: "Row level locking will be ignored" when I password-protect a split database?

Ack, sorry for the delayed response.

And thanks for the link, Bob. Will peruse that later. If I get incredibly lazy, I might just go back and remove the passwords entirely. It's more important that certain records lock, and I'm pretty sure no one's going to tamper with my back-end.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 14:08
Joined
Sep 12, 2006
Messages
15,613
Re: "Row level locking will be ignored" when I password-protect a split database?

personally, i think it is the locking that is generally not important.

you get a form of locking called optimistic locking anyway, which is good enough in most circumstances. i think record locking is quite a specialised requirement
 

boblarson

Smeghead
Local time
Today, 07:08
Joined
Jan 12, 2001
Messages
32,059
Re: "Row level locking will be ignored" when I password-protect a split database?

personally, i think it is the locking that is generally not important.

you get a form of locking called optimistic locking anyway, which is good enough in most circumstances. i think record locking is quite a specialised requirement

This is a good read about it and interesting stuff I hadn't heard before:
http://stackoverflow.com/questions/1118219/does-acedao-support-row-level-locking
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 14:08
Joined
Sep 12, 2006
Messages
15,613
Re: "Row level locking will be ignored" when I password-protect a split database?

pessimistic record locking is full of issues.

you need to maintain the locks for the minimum time possible. you need a strategy to reover from a deadlock.

in general i would much rather trust the access db process, and stick to optimistic locking.
 

smig

Registered User.
Local time
Today, 16:08
Joined
Nov 25, 2009
Messages
2,209
Re: "Row level locking will be ignored" when I password-protect a split database?

if you use record sets to update the data you should create your oun locking mechanizm (including recovers from deadlocks as said by gemma)
 

Users who are viewing this thread

Top Bottom