Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 11-04-2011, 12:41 PM   #1
Oimoi
Newly Registered User
 
Join Date: Jul 2011
Posts: 42
Thanks: 15
Thanked 0 Times in 0 Posts
Oimoi is on a distinguished road
"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. =)

Oimoi is offline   Reply With Quote
Old 11-04-2011, 01:25 PM   #2
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,769
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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?
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
The Following User Says Thank You to gemma-the-husky For This Useful Post:
Oimoi (11-04-2011)
Old 11-04-2011, 01:41 PM   #3
Oimoi
Newly Registered User
 
Join Date: Jul 2011
Posts: 42
Thanks: 15
Thanked 0 Times in 0 Posts
Oimoi is on a distinguished road
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:

Oimoi is offline   Reply With Quote
Old 11-04-2011, 01:48 PM   #4
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,825 Times in 1,578 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: "Row level locking will be ignored" when I password-protect a split database?

See if this thread helps:
http://www.access-programmers.co.uk/...d.php?t=208640
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-04-2011, 01:49 PM   #5
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,825 Times in 1,578 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
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.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-04-2011, 02:50 PM   #6
Oimoi
Newly Registered User
 
Join Date: Jul 2011
Posts: 42
Thanks: 15
Thanked 0 Times in 0 Posts
Oimoi is on a distinguished road
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.
Oimoi is offline   Reply With Quote
Old 11-04-2011, 05:12 PM   #7
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,769
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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

__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 11-04-2011, 06:54 PM   #8
boblarson
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,825 Times in 1,578 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: "Row level locking will be ignored" when I password-protect a split database?

Quote:
Originally Posted by gemma-the-husky View Post
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/1...-level-locking
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote
Old 11-05-2011, 06:21 AM   #9
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,769
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 11-06-2011, 04:58 AM   #10
smig
Newly Registered User
 
Join Date: Nov 2009
Location: Israel
Posts: 1,942
Thanks: 52
Thanked 131 Times in 122 Posts
smig is on a distinguished road
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)

smig is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I have set a password with "on click", how do I show "*" when entering it hardhitter06 Modules & VBA 16 12-20-2010 11:02 AM
Microsoft database engine could not find the object ""...." when running mde JoanneJames General 0 04-14-2009 08:09 AM
"locking" and "protecting" old data jeffm3434 Forms 5 01-24-2006 11:09 AM
"Type Mismatch" error locking down Access Malcy Modules & VBA 2 05-04-2005 12:23 AM
access a "password"-ed DataBase by form in other mdb file borislo Forms 3 01-06-2005 02:52 PM




All times are GMT -8. The time now is 12:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World