Hi,
I have a user getting a 3197 error, the description of the error makes it look like a write conflict.
However, after reviewing the code that causes the error, it doesn't make any sense because there is no record updating involved. It takes a predefined select statement, reads the form filter property and uses that to create a where statement, updates a query def stored in each user's front end (the db is split, data is on the network), and does a transfer spreadsheet to a file the user selects the name/location of.
I checked my code to make sure I'm not leaving any recordsets open anywhere that might be hanging it and they're all closed at the end of each routine.
here is one form where data can be edited that is bound to a query (which is basically select * from table), but the form is modal so they wouldn't be able to leave it open and work on anything underneath it.
Default record locking in the front ends in tools>>options>>advanced is "no locks", and "open using record level locking" is unchecked.
Any ideas what could be causing error 3197?
Thanks
-Lee
Tidak ada komentar:
Posting Komentar