.net – MS Access db over network share

ms-accessnetodbc

I have a simple web site that needs to connect to an access database over a unc share.

The server is a windows 2003 box running IIS 6. The connection is via ODBC.

We're receiving an error message that says "
ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Not a valid password.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I'm guessing that the IIS server doesn't have access to the share. The app pool is running under Network Service.

How can I fix this?

UPDATE
This just got weird. IF I have ReadOnly checked in the ODBC configuration AND No one else is attached to that database, then it works.

If someone else attaches to it then it gives me an error "HY000][Microsoft][ODBC Microsoft Access Driver] COuld not use '(unknown)'; file already in use."

If I uncheck the readonly configuration (no other changes), then it says "Not a valid password".

Best Answer

IF I have ReadOnly checked in the ODBC configuration AND No one else is attached to that database, then it works

That would suggest that you have read access to the share, but not write access.

Related Topic