To create a DSN connection log into to the control panel. Once you are logged in, click “DSN Manager” on the upper left.
Select Microsoft Access from the “New DSN” dropdown on the left. Click the browse button to locate your database in your folder.
Choose a name for your DSN. The name will be prefixed by your customer DSN identifier. For example, if you call your database “customers”, reference your DSN in your code as “A1735_customers”.