Im new to .asp and Im using Dreamweaver 2004 to allow the search of a basic Access 2003 database (.mdb).

I have set up the DSN connection, installed IIS on my XP Pro machine, created my site in Dreamweaver, set up the local and testing servers. I select ASP VBSCRIPT as my webpage file type.

On my search page (search_1.asp) I have added a form, list menu and search button. Then I have click on databases and added the database (resources.mdb) I have tested the connection and it connects. Then I have click on Bindings and added a recordset which again I tested the SQL in dreamweaver.

My problem starts when I add the recordset. When I hit preview (f12) the .asp page does not load, instead I get the following Internet Explorer error -

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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 have looked at loads and load of websites with regards to this error message (theres plenty of them!!) but so far none have solved the problem, not even microsofts own.

Any help would be very good!!

Welcome Billy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

IUSR_MACHINENAME needs to have write permissions for the folder that the database is in, that should fix it.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

How do I go about setting the write permissions up? Is it within access? Im totally new to permissions as well im affraid, but Ill get there in the end!!

Thanks for your reply, much appreciated!!

Billy
<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Hi Billy

Navigate to the folder in Windows Explorer, right click the folder, select properties, go to the security tab, select IUSR_MACHINENAME it will have read access to it, give it write access too.

Sharing Knowledge Saves Valuable Time!!!
~ ~ ~ ~ ~ ~
<b>Lee Diggins</b> - <i>DMXzone Manager</i>
<font size="1">[ Studio MX/MX2004 | ASP -> VBScript/PerlScript/JavaScript | SQL | CSS ]</font>

Ive done all that, but no success. Then I entered my own password for the IUSR account and within dreamweaver on the DSN connection i included the IUSR account and password. This seems to have sorted it <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>