connecting to an Access database

[oa2005]

I am trying to connect to an Access database from the web using perl. Although I've been able to do this successfully through perl via the command line, when i try to do the same from an Apache web server, i get an error message about the connection.

"failed: [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. (SQL-HY000)(DBD: db_login/SQLConnect err=-1)".

I've ensured that the database is closed etc.
any suggestions?

 

[duncdude]

When you run from the command line you have a known identity - You will need to grant permissions for a web user to access the database as this is under a 'public user' identity

read this post:-

http://www.tek-tips.com/viewthread.cfm?qid=857863

Kind Regards
Duncan

 

[Rieekan]

It also appears that you have the database open already by a user that is not the Nobody ID your webserver uses. When running this, make sure you do not have the database open in a design mode.

- Rieekan