Knowledgebase

DSNless connection to MS Access

Here are some examples of DSNless connections to MS Access - this is highly
recommended over using ODBC

This also assumes you have created a "private" folder in the FTP root for
your account.

Remember to replace your-account-name with your own account
name.



OLE DB Provider for Microsoft Jet For standard security (ie No db password
assigned)

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
 "Data Source=D:HSHomeyour-account-nameprivatedatabase-name.mdb;" & _ 
 "User Id=admin;" & _
 "Password="

If using a Workgroup (System Database)

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
 "Data Source=D:HSHomeyour-account-nameprivatedatabase-name.mdb;" & _
 "Jet OLEDB:System Database=MySystem.mdw", _
 "myUsername", "myPassword"

Note, remember to convert both the MDB and the MDW to the 4.0

database format when using the 4.0 OLE DB Provider.



If MDB has a database password

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
 "Data Source=D:HSHomeyour-account-nameprivatedatabase-name.mdb;" & _

 "Jet OLEDB: Database Password=MyDbPassword", _
 "myUsername", "myPassword"

If want to open up the MDB exclusively

oConn.Mode = adModeShareExclusive
 oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
 "Data Source=D:HSHomeyour-account-nameprivatedatabase-name.mdb;" & _
 "User Id=admin;" & _
 "Password="

If MDB is located on a remote machine

- Upgrade to SQL Server and use an IP connection string



If you don't know the path to the MDB

<% ' ASP server-side code
 oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
 "Data Source=" & Server.MapPath(".") & "myDb.mdb;" & _
 "User Id=admin;" & _
 "Password="
 %>

This assumes the MDB is in the same directory where the ASP page is running.
Also make sure this directory has Write permissions for the user account.

 

Add to Favourites    Print this Article

How do I backup and restore my Website and Databases. (Views: 2323)

Microsoft JET Database Engine error '80040e14', Syntax error in... (Views: 5751)

How do I set the database permissions for a Microsoft Access file (*.mdb) on Windows Plesk. (Views: 3095)

How can I BACKUP a MySQL database from the command line? (Views: 3157)

How do I REPAIR all MySQL databases on my virtual / dedicated server? (Views: 2145)