access 2k database connection

[lordhuh]

i have tryed every possible way i can find to connect with my database. i either get something about cannot open registry key or some permision thing. please can someone show me a corectly formed dsnless connection to a 2k database Karl Pietri

http://www.crantorland.com

 

[hblackorby]

set conn = server.createobject("ADODB.Connection&quot
ConnString = "Driver=Microsoft.Jet.OLEDB.3.51; Data Source=" & Server.MapPath("database.mdb&quot
conn.open ConnString

Note that this uses OLEDB connections on an Access database without a user name or password.

For a password protected Access database use:

username = "fred"
password = "fredpass"
ConnString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb&quot & "; UID=" & username & "; PWD=" & password
Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[jonscott8]

You also might want to read the comments of:
ACCESS2000 Connection
thread333-82724 Jon Hawkins