How can I use MiniVend with Microsoft Access?
Though MiniVend has ODBC capability, the Microsoft Access ODBC driver is not a network driver. You cannot access it on a PC from your ISP or UNIX system. However, you can turn it around. Once you have created a MySQL or other SQL database on the UNIX machine, you may then obtain the Windows ODBC driver for the database (mySQL has a package called myODBC) and use the UNIX database as a data source for your PC-based database program. Here is a quick procedure that might get you started: • Get and mySQL from: http://www.mysql.com Install it on your UNIX box. On Linux it is as easy as getting the RPM distribution: http://www.mysql.com/rpm/ You install it by typing, as root, rpm -i mysql-3.XX.XX.rpm. If you are not root, you will have to build the source distribution. • To avoid permissions problems for your testing, stop the mysql daemon and allow global read-write access with: mysqladmin shutdown safe_mysqld –skip-grant-tables & Obviously, you will want to study mySQL permissions and set
