I'm having a security problem with MS Access and do not know where to start looking. I'm writting some procedures in the backend of a db. I'm reconnecting to that same backend using ADO to perform some operations on a table. I keep getting a connection problem that is not consistant. It only seems to happen when ever I make a change to the code and do not save the change.
The error is Run-time Error '-2147467259 (80004005)' The database has been place in a state by the user "<user name>" on machine "<machine name>" that prevents it form bing opened or locked.
My colleague and I think the problem lies in the fact that the db is opened and then we try to reconnect to the same db to perform queries on a table.
Has anyone seen a similar problem or have any other suggestions as to what the problem might be. I'm out of ideas for the moment.