jet engine in use by another person 1

[croakyfrog]

has anyone come accross this error before? i am getting it on an access frontend to a sql database (bit wierd, i know), i've tried rebooting and deleting the .ldb files with no joy yet.

thanks!

 

[mmsbasd]

I had a similar issue. Basically, another user (call her USERX) got dumped out of SQL and the server continued to list her as still connected. In my case, it was a bunch of records that were locked out. The only way I was able to get the database to work properly was to login as USERX and then go into and back out of the locked sections. At that point, SQL released the sections and all was well. Your error message should indicate the user who is locking the files/database.

Some other things that may help:

If the problem is with the Access frontend and you're using Windows 2000/XP, it may be that another user logged into that machine, was in the database and never logged out. Again, log in as that user and get them out.

You could also try a COMPACT AND REPAIR on the Access frontend.

Hope this helps.

 

[croakyfrog]

brilliant - thanks - i tried to give you a star but it doesnt seem to be working so if the moderator is listening - your star-giving system is broken and has actually been for a while.