Connecting to Access 2000
Written by Eric Smith, Northstar Computer Systems LLC
This question keeps coming up, so I’ll answer it again. To connect to an Access 2000 database, you need to use the Jet 4.0 provider with ADO/OLE DB, like so:
Dim dcnDB ' As ADODB.Connection
Set dcnDB = Server.CreateObject("ADODB.Connection")
dcnDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=D:\Mydatabase.mdb;"
dcnDB.Open
I’ve seen some users using syntax involving DBQ and curly braces, which seems to work OK. However, MSDN uses this method and syntax for examples, so that’s what I stick with.
Keywords: [
Uncategorized ASP Tips
]
Publication Date: 6/1/2000
|