Help please -- must be simple. Upsized an Access 97 database to SQL 7 - all seems OK (so far) except when we add or update a record in a FORM, it locks the record - and I cannot get it unlocked.
When I add a record directly through enterprise manager, it also locks.
When I update the record through the linked Access table it DOES NOT lock.
And, finally, there is a tabular subform of the continuous form which I am getting the record locking -- adding a record to the sub form DOES NOT Lock.
Other info:
1) There is quite of bit of code behind the forms - (at least continuous forms are causing the problem) But no ADO or DAO
2) I am getting the error - ..."you and another user are attempting to edit the data at the same time" - #3197 - stating the table is optimistically locked
3) I have not created any triggers -- but will check it on my next visit (I can remotely run the application, but cannot remotely run Enterprise Manager)
4) Adding a record through a table in Access does not lock it, adding through the forms AND adding directly through Enterprise Manager does cause the locks.Thank you in advance for any assistance.(I will also post on Access forum)
Please help, really need to get this addressed this weekend.
Thank you,
Nancy
When I add a record directly through enterprise manager, it also locks.
When I update the record through the linked Access table it DOES NOT lock.
And, finally, there is a tabular subform of the continuous form which I am getting the record locking -- adding a record to the sub form DOES NOT Lock.
Other info:
1) There is quite of bit of code behind the forms - (at least continuous forms are causing the problem) But no ADO or DAO
2) I am getting the error - ..."you and another user are attempting to edit the data at the same time" - #3197 - stating the table is optimistically locked
3) I have not created any triggers -- but will check it on my next visit (I can remotely run the application, but cannot remotely run Enterprise Manager)
4) Adding a record through a table in Access does not lock it, adding through the forms AND adding directly through Enterprise Manager does cause the locks.Thank you in advance for any assistance.(I will also post on Access forum)
Please help, really need to get this addressed this weekend.
Thank you,
Nancy