dhotchin — Wed, 04 Feb 2004 16:54:09 +0000

Thanks all. I have found what the problem is. In IIS there was to setups. On was our Intranet the other was ASP (my old test run). We had a problem with one of our servers and it made ASP not run (permison error). So i created the site again. And it still did not work. The reason for the was i had changed the file stucture so the ASP pathon ISS didnt work no more. So all i had to do was delete the ASP virtual directory in IIS. and it worked.

If i was not goin to use access, what else could i use? and how easy is it to change?

m3rajk — Sat, 31 Jan 2004 17:49:15 +0000

i'll send this thread to my sister. she knows asp (might ight be asp.net that she knows) and she has created several dbs for a company all in access. so she might be able to help.

Abhishek Reddy — Sat, 31 Jan 2004 07:41:08 +0000

Well, it definitely sounds like a database problem. Check that your db setup is identical as well as ASP/IIS. Check the basics first. Are the paths the same? Is the database properly created/copied?

Mark Hensler — Fri, 30 Jan 2004 17:49:24 +0000

I haven't worked in ASP for over 3 years now, and I never ran a site off of Access. So I don't know how much I can be.

Sounds like your using DSN-less connections? If not, try that.

Other than that, I can only guess permissions on the database (.mdb file).

dhotchin — Fri, 30 Jan 2004 10:14:58 +0000

I think i have ruled out that it is not the file name problem. Create new file, new database, new connection, new everything. And it still appears with

HTTP 500 - Internal server error
Internet Explorer

Nothing has changed in IIS and ASP still works becuase i tryed the "Date and Time" test.

Thanks again