Hello,

I have a System DSN that points to a Microsoft Access Database. I'm running some VB code to get the records through my own utility. Anyhow, when I run the utility to execute the VB code, everything works fine.

Now, I have a Windows service that can run windows executables. When I run the same utility through this service, it does not work, I get the following errors:

Last error: ERROR [HY000] [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.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [HY000] [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.

I am very confused how the utility can work when I run it directly, but doesnt work when I run it through the service. I'm guessing it may be a permissions / security issue. The Access Database is on a shared network drive. If anyone has any ideas, please let me know. Thank you.

put the error on microsoft.com site and try.

assuming IIS,

the IUSR_machinename user on the webserver must have read/write permission to the folder the .mdb is in or be in a group that has access.

Originally Posted by chrishirst

assuming IIS,

the IUSR_machinename user on the webserver must have read/write permission to the folder the .mdb is in or be in a group that has access.

Thanks, this worked for me. I just wanted to run some database query demos locally using iis on a laptop as localhost. The mdb files were not under inetpub.

Hi,
I try to open the MS Access file from network drive, but, it give me this error "Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site. Microsoft Access will not open the file due to potential security problem.".

I search at microsoft website,but the solution not really help. Does anyoe know how to resolved this problem?
Thanks.

Put the file into a shared folder on the drive, indera. That usually solves it.