ODBC Cannot lock all Records

[Caracarn]

Hello, I have just used the SQL Server Migration Assistant 2005 for Access (SSMA) to convert all of my Access tables into linked tables in a SQL Server 2005 database.

Everything appears to have worked fine, but now when I open any form I get the following error.

ODBC--Cannot lock all records.

If I click OK the form loads and everything appears to work OK, but the error is annoying and I want to get rid of it. Doing a Google search people have suggested going into the Tools\Options\Advanced menu and setting Default Open Mode to Shared and Default Record Locking to No Locks. Unfortunately this made no difference.

I thought the problem might be in my On Load code for the form and put in a break point, but the error appears immediately before the breakpoint is triggered, so it isnt my code thats causing the problem.

Can anyone assist in getting rid of this error?

Any help is much appreciated.

 

[Caracarn]

Well I managed to fix the problem myself. One of the subforms for some reason had it's Record Locks field set to 'All Records'. Once I changed this to 'No locks' the error disappeared.

 

[pcride]

I need help on this error as well.

I have migrated all my data to SQL 2008. I then changed the form fields to link to the SQL Server table. Now I get the error when trying to switch into Form view from Design View.

I have already checked the settings and I am not sure what it could be.

 

[pcride]

I was able to find the option. IT was the form option in the properties, I had to set this to Editor Locking etc..