HTTP 500.100 Internal Server Error- ASP Error IIS

[student2]

Hi,
I'm a student looking for any recommendation to finding a solution to the following problem.

(Hope I'm posting in the correct 'section' of the forum, since my error says both IIS and ASP) I'm not quite sure if it is an IIS problem or an ASP or either :S

I'm running IIS on my WIndows XP Pro OS.
I'm connecting an Access database (.mdb file) to Dreamweaver CS4.
I've made the connection with the following string

"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=C:\Inetp ub\wwwroot\mySi te\mySite.mdb;"

When tested it shows as successful. If I add words, tables, images and simple html codes it works fine when tested and previewed through the web browser.

However, once I add a recordset/or query it produces the following error:-

HTTP 500.100 Internal Server Error- ASP Error IIS

Error Type:
Microsoft Jet database engine cannot open the file C:\Inetpub\wwwr oot\mySite\mySi te.mdb
It is already opened exclusively by another user or you need permission to view its data
/mySite/index.asp/line 9


Line 9 is where my recordset is when I view the code.
I've tried IUSR/Localmachine
I've tried to work with user permissions
Uninstalled and re-installed IIS
I seem to be getting no solution.

Any help rendered would be greatly appreciated.
Thank you :-)

[jhardman]

This is an extremely frustrating point to be, and one of the reasons I like to log in to dbs with a SQL login rather than a windows login (one more reason I moved away from access, but I think you can log in to access with an application login rather than a windows login). I definitely think it is a permissions error, make sure iusr_machineNam e has permission to read / write / modify the file AND the folder where it's located

Jared

[student2]

It certainly is a frustrating place to be!
Thanks Jared this was in fact the solution.
:-)