Relative linking to Access...

[JohnMitch]

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]

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]

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: Select all

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]

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]

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]

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

[JohnMitch]

Thanks Guys. Finally got the dern thing working!