Row level locking error

[mafhobb]

What is "row level locking"?

How can I get around the "encrypting with a block cipher is incompatible with row level locking" error

I've never had this error before and I do not know what I did to cause it

mafhobb

 

[Isskint]

Is this in Access 2010? I am not 100% sure of the mechanics but if you want to encryt your databsase, then forms can not have record locks enabled - EG restricting multiple access to the same form/data.

 

[mafhobb]

It is a 2003 database that has been converted to 2007, User-Level security removed and split. It all works fine up to the point when I try to encrypt it.

What does "record lock" mean? Is this an option on the database options? Is this locking a field using the .locked property?

mafhobb

 

[Isskint]

This a form level restriction. If you go into the form properties box you will find the Record Lock seeting on the DATA tab. It essentially allows you to determine how the underlying data is handled when a formis open - multiple users can edit the same record, records are READ only or when a user starts editing a record it is 'locked' so no other user can edit it also.

 

[mafhobb]

OK, I needed the record locking so I went to the options tab and used a different type of encryption to avoid the error. That did it.

Thanks isskint!

mafhobb

 

[ozmike]

hi

some more info

Access 2010 -> File -> Options -> Client Settings -> Adavnced -> Encryption Methods -> Use Legacy (good for multi user).

This got rid of the locking message. I found however that once you had encrypted the file with the default setting it would not pick up the lower setting. Try using an unencrypted backup file. I used an MDB which I converted to a Accdb . Then set the encryption with the lower setting - locking message dosen't appear.

to trolls - sorry for answer an old post - but the last answer was frustratingly close..