Windows Vista Ultimate - Connecting to an Access DB in IIS 7

[Anthony1312002]

Hello everyone. I just recently moved to Windows Vista Ultimate from XP Pro on my desktop machine which of course means I'm running IIS 7. I'm able to view asp pages that don't connect to an access database by way of an include file I have in the wwwroot directory. But when I try to access any page that has this include file I get the error number #500 this page cannot be displayed. I took a look at whether or not the IUSR user has Adminstrative rights. Interestingly this user does not appear in the Users folder but only in the Groups folder. Could this be part of my connection problem? And if so, how do I add the user IUSR to the Users folder?

[kenobewan]

So this appears to be an Access problem?

[Anthony1312002]

Could it be the type of connection I'm using. Here is my connection script:

dbpath = "D:\accessdb\te st\billing"
CommStrStart = "Provider=Micro soft.jet.oledb. 4.0;data source="
If Session("SName" ) = "Charlotte" Then
DataConn = DBPath & "\CharlotteBill ingData.mdb"
End If

Set Conn = Server.CreateOb ject("ADODB.Con nection")
ConStr = CommStrStart & DataConn
Conn.open(ConSt r)
Set cmdDC = Server.CreateOb ject("ADODB.Com mand")
cmdDC.ActiveCon nection = Conn

[Anthony1312002]

By the way, my database was created using Access 2003 and I've recently upgraded to Office 2007. This worked on my XP Pro setup but not having the same success in Vista.

[kenobewan]

Try connection string:
Provider=Micros oft.ACE.OLEDB.1 2.0;Data Source=D:\acces sdb\test\billin g\CharlotteBill ingData.mdb;Per sist Security Info=False;

Your code needs optimizing:)

[Anthony1312002]

Thank you for the response. I'm unfamiliar with this kind of connection. When you say that the code needs to be optimized what do you suggest. I'm somewhat new at coding.