Database Security (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

xterradane -> Database Security (1/14/2002 20:49:06)

I will make it easier this time: Does anyone know how to set a password up in Access and then use it in the connection? It should be something like this, but I can't get it to work:

Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=D:\Inetpub\wwwroot\Database\JobBoard.mdb;" &_
"Jet OLEDB: Database Password=xxx"


 



daveh42 -> RE: Database Security (1/14/2002 21:41:27)

I think you need to set the Database Password after the Set statement using the Properties collection like this:

objConn.Properties("Jet OLEDB:Database Password") = "xxx"


Hope this helps,
Dave



Spooky -> RE: Database Security (1/14/2002 23:06:02)

Check out http://www.frontpagewebmaster.com/topic.asp?TOPIC_ID=9488 as a good resource!

§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login



xterradane -> RE: Database Security (1/15/2002 9:33:56)

Thanks so much. Great information! Hope I can get it to work tonight. You guys are wonderful!

 



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.03125