Placed in a state By User/Admin on Machine ERROR

[edisonl]

Hi,

1) My application calls up differents form.

2) In every form I wrote coding creating .ADO & .Recordset instances to compare user input data with previous record in my table for some error checks. (Eg: Login Screen Test for existing UserId, Account Name Test for correct account no)

3) I have encountered error messages:
"The Database has been placed in a state By user Admin on machine ABC that prevents it ..... message"

4) Had check my version of msjet40.dll, version is 4.0.8015.0

5) What possibly could be the causing ?

6) Thanks in advance for advising

Thanks & God Bless

 

[boblarson]

Could it be you aren't using

CurrentProject.Connection

as the connection string and are instead trying to use the same code you would use to access an external database?

 

[edisonl]

Right Will go and try

Thanks, will go n check it out.

Thanks & God Bless

 

[ewc]

While I never did figure out why the error occurred, the error most likely is caused by a hidden admin login in a Workgroup Admin account (without you even setting one up). The fix for me was to create a new blank database and import all objects from the damaged database. Rename your old DB (myDB_OLD.mdb) then import the objects then you can create the new database with your original name. Compact and Repair the new database.
Try it. It worked for me.