I'm sorry if this question has been answered before, I searched all I could in the archives of the forum but could not find any answer.
I'm using the latest stable versions of Appache and PHP, and I'm trying to interact with an Access database using PSP. I've read "Interacting with MS Access 97" by Siddharth Venkatesan, and I'm basically trying to get his exemple to work for me.
After a bit of research and scrambling, I added php3 to the AddType in my Appache Server and got rid of the "Post Method not allowed", but all that did was change the error message I was getting. The error message I get now is:
Warning: SQL error: [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 state S1000 in SQLConnect in C:\Program Files\Apache Group\Apache\htdocs\DataAccess.php3 on line 28
My database is not opened, I have access to it when I open it with MS Access, so I'm stumped. I have a feeling I should change the user in the exemple to something else than 'root' but I don't know what to change it to.
Thank you for your help, it is much appreciated.
Brigitte
