connecting to just a ccess® db WITHOUT odbc connections???

one of our 'clients' has said...

"quote...I generally do not like to use ODBC DSN-based connections, simply because of the issues that arise if the site is moved to a new computer (need to recreate DSN). I have always used DSN-less connection strings for simplicity of maintenance.

Not sure why we need to use an ODBC connection... I've never used them before, and I've developed a bunch of sites that read/write to MS Access databases...endquote"

ummm...can this just a be® done with vb???

QuackHead tries to understand what Justame means... :confused:

hehe, I think I got it, but I may be wrong.

Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; data source=c:\path_to_database.mdb"
conn.Open

conn.Close

a couple notes...
[list=1]
"conn" is just a variable name, you can change that to whatever you want.
the 4.0 in the connection string represents MS Access 2000. For an earlier version (such as 97) I think it's 3.1 or something.
[/list=1]
Now, If I understood the question properly, that should do you.

If not, I'm messed. :D

~Quack

qua...
just a tas® for your understanding of the 'question'...hehehe.../me will pass it just a long® to the techies n' see ifin' it makes sense to them...lol...