Database engine cannot open the file unknown

It's not permissions. It's that the database is actually opened in MS Access somewhere. Opening an access database with the MS Access itself is different than connecting to it from another program. MS Access will lock the db while you work on it.

You need to find who has it opened in MS Access and beat them over the head until they close the Access program. After you do that, report to my office so I can beat you myself for choosing Access as a web database.

That's a really dumb thing to do, because Access is an in-process or desktop class engine. Web sites really need a server-class engine like sql server express that can do a better job handling concurrent users. For those who crash here with the same error. This resolved my issue.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 11 years, 11 months ago. Active 3 years, 8 months ago. Viewed 3k times. After rebooting the system this problem occurs. It is already opened exclusively by another user, or you need permission to view its data. The program is executed and it runs perfectly.

After the machine is shutdown and the program reexecuted the following messaage is seen. This happens in few of the systems in the network. The Microsoft Jet database engine cannot open the file. Was this reply helpful? Yes No. Sorry this didn't help. Lorren Zemke Staff answered 6 years ago. Adrian, The error message is saying the file is either open or the user you are logged into the windows machine as does not have access to the file.

Duplicating the map will not change the fact as the issue would be with the permissions trying to read the file. Adrian F. Harris answered 6 years ago. I am using smart connect to insert a GL batch, the map calls a store procedure. I have access to the files because I can see the batches I have created. I am the same user running the script I doubt it is a permission issue. I copied the map to a new map, when I run the new map it give me the error.