ok, I contacted my admin. I don't know whats wrong. He created a special folder for access databases on my server. I put the database in that folder and then tried to open the forum again, when I hit default.asp I get this error,
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/common.asp, line 424
When I try to hit user_login.asp I get this error,
HTTP/1.1 404 Object Not Found
My admin told me I needed to use this connection string to connect to the database, will this work with the forum? If so how can I use it instead of what ever it's using now?
Connection string for a password-protected database looks like this:
strConn = "Driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("/_data/yourdatabase.mdb") & _
";pwd=myPassword"
without password protection:
strConn = "Driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("/_data/yourdatabase.mdb")
Thanks.
Edited by spikeashlye