Relative linking to Access...

JohnMitch · August 9th, 2005, 05:03 PM

My problem that I am having is that I have always used a DNS for my databases and I haven't ever done this before. Here is my problem.

I need index.asp to submit a form to Data.mdb . Data.mdb is in the same folder as index.asp so all I need is a relative link (I believe). I have tried using the tutorial on this but have had no luck. My database has a password on it so lets just call that DUCK. Anyone that can give me the code for this will be forever in my gratitude.

Thanks guys!

D3mon · August 9th, 2005, 07:21 PM

I usually use something like:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("mydb.mdb")

be aware though that hvaing the database in the root of folder means it is exposed to the possiblity of being directly downloaded. Best to place it in a non-public folder.

JohnMitch · August 9th, 2005, 07:51 PM

Yeah, I am not worried about people downloading my database as this particular one has nothing of value or use to them inside of it.

Thanks for your help D3mon, but how do I add the password to this to open it? I've been trying this:

Code:

Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
ConnectionToDatabase.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("MYDB.mdb") & _
						  "Password=DUCK;"

What this does is it adds Password=DUCK to the end of the databse name instead of unlocking the dern thing. Any suggestions with this?

D3mon · August 9th, 2005, 07:55 PM

http://www.connectionstrings.com suggest:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("mydb.mdb") & ";User Id=[username here];Password=[password here];"

Webforumz Staff · August 10th, 2005, 03:49 AM

Personally I've never had any luck using a password with Access, but maybe I just never did it right.

Funny, I avoided SQL Server for years thinking it was intimidating, but in now think it's easier than Access. (Not that you're using it for that reason)

benbacardi · August 10th, 2005, 04:24 AM

just add a semi colon before the world Password in your string...

JohnMitch · August 10th, 2005, 11:19 AM

Thanks Guys. Finally got the dern thing working!