Microsoft Access Strings

ETI supports Microsoft Data Access Components 2.1 SR2. Please ensure that all your database connection strings have been converted from the Microsoft Access database driver to the OLE DB driver as it is more efficient and reliable. Converting the connection strings should improve site performance as well as server performance.

Below is the code for sites that have Microsoft Access databases that are protected by either a database password or by database user logins. If you are just using a database password then username should be 'admin' and the password should be blank or not included in the string. If you are using user logins alone then the database password should be blank or not included in the string.

Convert connection strings from:

strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=e:\inetpub\users\username\domainname.com\
database.mdb;UID=" & UserName & ";PASSWORD=" & Password

or

strConn = "DSN=NAME"

to

strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=e:\inetpub\users\username\domainname.com\database.mdb" & ";Persist Security Info=True;User ID=" & UserName & ";Password=" & UserPassword & ";Jet OLEDB:Database Password=" & DatabasePassword

The FTP virtual directory db is located at \username\db You can use this directory to secure your database so that it cannot be downloaded without proper authorization. The database connection string is usually located in the global .asa file or in .asp files. .