[cobalt-users] Re:Microsoft Access Database

[Grant Stern <grant@xxxxxxxxxxxxxx>]

> I suggest you go and cut your lawn with scissors, it will be far easier!
> Seriously, you would be a lot better moving it to MySQL or PostgreSQL (or
> Interbase) database servers.  Those will run on the RAQ4 under Linux whereas
> Access won't. If its on a Windows (bad language) box on local net (ie not
> the internet) you could convert it to an MDE file (if its Access 2000) and
> install MSDE from the Access 2000/ or XP CD. That is a cut down version of
> SQl Server, and will allow net work access.


I agree with David, but propose a more useful solution.

http://www.cynergi.net/exportsql/

This lovely little (unsupported, but get used to it, you've got a cobalt)
script has decent instructions on how to create a MySQL dump file.  Once
you've created the file, and uploaded it, use this command in the shell
prompt, logged in as root, to make your new MySQL db.

  mysql yourdatabasename < dumpfilename.sql

Also try phpMyAdmin to go with MySQL.  Good luck!
Gs
-- 
http://heybartender.org
High Impact Design