Error (0x80004005)

any help?

[Andrew Thomas]

I get the following error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

the strange thing is that my program was working, then all of a sudden this message is appearing and i cant solve it.

Ive looked on google groups and tried all they have said, including registering the OLE DB .dll's. Checking permissions etc. I have no passwords on the database, and im the only user using the database as its on my local machine (for testing)

Is there anything i havent tried?
thanks for any help

[SuzyUK]

have you got the database open in Access? as well as trying to use it via server..

PS: This shoud really be in Microsoft forum

Suzy

[Andrew Thomas]

sorry - maybe a moderator could move this to Microsoft forum please.

The database was created in Access, but it is closed while trying to test.

[SuzyUK]

I don't know enough perhaps there's a infinite loop going on?

or you haven't explicitly closed the connection and the session still thinks it's open..
e.g.
' alway close connection and set recordset to nothing
objRS.close
set objRS=nothing
objConn.close
set objConn=nothing

if it's this your server may need a reboot to cut the connection first...

I do remember this happening to me a few years ago but can't
remember all the things I tried....

Try reposting the message in the Microsoft Forum, Sorry not to be more help

Suzy

[defanjos]

This happens to me all the time since I changed to a computer with Windows 2000 pro - on Win 98 never had the problem.

It happens after you open the Access database. The only way I found to fix it, was to create another folder, for example "database1", copy the DB into it, than delete the folder were the DB was before. Now rename "database1" to "database" - assuming this is the name of the original folder.
Now go to Windows Explorer, find the folder, right click on it, click properties, then security tab > click Everyone > check full control > Apply

If anybody else knows an easier way, I'd love to know it.

[Andrew Thomas]

Ahh- thanks defanjos

That worked! I was starting to pull my hair out.

Im using WinXP professional. I'll have to remember that trick

thanx again

[defanjos]

I am glad it worked.

Another thing, if you need to view/modify your Access database often, create another folder (i.e. DatabaseView) and use it to place the db in there to make changes and view. When you are done with it, copy it back into "Database"