469,568 Members | 1,523 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

HTTP 500.100 Internal Server Error- ASP Error IIS

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=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\mySite\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\wwwroot\mySite\mySite.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 :-)
Oct 4 '09 #1
2 5061
jhardman
3,406 Expert 2GB
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_machineName has permission to read / write / modify the file AND the folder where it's located

Jared
Oct 5 '09 #2
It certainly is a frustrating place to be!
Thanks Jared this was in fact the solution.
:-)
Oct 6 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by James Owens | last post: by
4 posts views Thread by Dean R. Henderson | last post: by
9 posts views Thread by CMan | last post: by
9 posts views Thread by LVP | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.