Access and ODBC

From Edgar BV Wiki
Jump to navigation Jump to search

>I'm afraid you're going to need a Windoze server to do MS Access files >directly. If you are using ChiliASP, there is a linking program called >SQLLink to remotely connect to an SQL database, but I have never tried >it.

We've successfully implemented it but it isn't fun and IMHO, working with Access is a real pain.

If you are dead set on using Access then check out: http://pkgmaster.com/howto/casp_access_howto.shtml For the tutorial on how to setup sqllink:

>We broke down and learned MySQL and purchased a product from >Intelligent Converters called acc2sql. >http://www.convert-in.com/acc2sql.htm

You can get a fee converter from mysql.com. Look for the MyAccess download on this page: http://www.mysql.com/downloads/os-win32.html

We've used it to successfully convert an access db to MySQL.

Brian