[RESOLVED] why this connection string doesnt work?

delete

Which version of access are you using?

You should have the local path to the mdb file. I've never seen one with http://.... etc

what path should i use if my ASP VB program is in the http://weblab.devry.edu/LNGBIS355XSU...YouthBookstore

folder and i copied the mdb database to the same folder for simplicity .

- by the way, is it ok to just copy the mdb file to a different folder?

weblab.devry.edu/LNGBIS355XSUM08A/PMcDonald/FountainOfYouthBookstore

I am going to tell you the truth, I don't even know if you can access a database on the internet. I am 90% sure that the database needs to be on your PC. Though I could be wrong.

yes, but the script runs on the same server , i run it from the server, not from my pc
go to and run it yourself and see what error you get

http://weblab.devry.edu/LNGBIS355XSU.../HomePage.aspx

Your connection string that you posted is not what is being used on the server. Post the code that the server is using to open the database.

Quote:

---

Originally Posted by eclipsed4utoo

Your connection string that you posted is not what is being used on the server. Post the code that the server is using to open the database.

---

i thought the only infotrmation that was important was what folder the mdb database file was in.. i know there is no password or username

yes, you are right... only the directory is important. And yes, scripts can access it from the same server. I doubt your website resides in the root directory of the c drive. If you're not sure, put this code in a page:

Code:

---

Dim path as string = Server.MapPath(".")
response.write(path)

---

HTH