I am using MS Access as a front end to a postgres database running on a Solaris Unix box, using odbc as the
communicationmedium.
One of the main tools of my Access app is a process that runs at night to process student progress in an online
trainingsystem.
A couple of nights ago the app started generating the error:
"Runtime error 3046: Could not save; currently locked by another user"
and it is on the app screen when I come in in the morning, locking up the program and keeping it from completing. I
trapas many errors as I can think of, but this is escaping trap so I don't know where in the code it is happening.
I am sure that the error is not from an Access user A. because the process runs between 11pm and 1am and 2. because
thereare no .ldb files open, a file type created when a user opens an access application.
So, is there any way to determine what records are locked, if in fact that is the problem? (As you know, the error
reportedmay not actually be the underlying problem).
Most of the program is designed with classes instantiated as objects, and in Access when I take the 'debug' option of
theerror message box, all that happens is the program goes to the first process of the first object, so that is
useless.
If no one has an answer I will probably write a routine that steps through every record of every table and attempts to
lockit to see if I can reproduce the error that way.
Thanks in advance for any suggestions anyone may offer.
Fred Parkinson