Recent content by 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.

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...

The tables are just for testing, but the design will be what I will use, if I can get it working. What you have done is exactly what I am after, except for one small problem. There will be 7 state subforms, 1 for each state. I want to be able to see all of my offices, across all of our states...

Hello HiTechCoach, Thanks for your help, but i'm still having problems. I have done what you suggested and used separate tables for each form, but my requery does not seem to work, I'm obviously doing something wrong. I have added the same code to OnClick and OnCurrent because I want the...

Hello, I have a main form (Offices) with 2 subforms (State) and (Details). The State subform contains a list of offices in that State in a continuous form so I see all 12 offices in the subform at once. I want to be able to click on the OfficeName field in the State subform and have it update...