Record locking in ADP

[Greg Snidow]

Greetings all. Is there a way to turn off the default record locking in an
ADP. I am trying to input data into a form based on a view. It lets me save
some fields, but not others. I get the 'save record', 'copy to clipboard',
or 'drop changes' warning, when I am the only one in the database. I have
Access 2003, but my ADP is in 2000 format. My server has MS SQL2000. Thanks
in advance.

 

[Greg Snidow]

I should have included the information that no matter how many times i choose
'save record' the dialog box does not go away. I can find no way to save
these records. Thanks

 

[Sylvain Lafontaine]

Probably that this has nothing to do with record locking. The first thing
to look is to make sure that you have defined a primary key for the table.
Also, using some types of field like Bit or using Real instead of Float can
be the cause of this problem.

The best way to know what's happening is to take a look with the SQL-Server
Profiler: you will see what's ADP is trying to do and why it fails.

Finally, there is a newsgroup about ADP: m.p.access.adp.sqlserver.

 

[aaron.kempf]

wow Sylvain, im impressed.. you managed to say 2 sentences without
scaring people away from ADP