Unkonwn Problem

[Paul Ilacqua]

I converted a 97 database to 2002 and when running any
ADO type recordsets against a Jet type recordset I get
message "The database has been placed in a state by user
'PaulJ' on machine 'BCSDEV' that prevents it from being
opened or locked." If I close the database and reopen it,
it's OK until I edit the code in any way then this error
message is raised. I tried recompile, the normal things.
Any ideas?

Paul

 

[Eric Butts]

Hi,

How are you opening the recordset?

Try something like this:

Dim rs As ADODB.Recordset

Set rs = New ADODB.Recordset



rs.ActiveConnection = CurrentProject.Connection

rs.Open "tbltemplatedate", , adOpenKeyset, adLockOptimistic, adCmdTable


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support