How can I setup a access DSN to use ODBC?

You have to upload your access .mdb to the /database/ folder on your webspace, If you have deleted this directory just go to your control panel and click ODBC settings, and it will be recreated. Your databases have to be in this directory to be write enabled, else you will not be able to update your database and will get permission errors.

Once you see the .mdb file on your control panel, ODBC settings, click the file you wish to use, and type in your desired DSN handle. Thats it! you dont have to wait for any confirmation, your DSN is ready to use.

back