[GRLUG] Access->MySQL with GUI

[Jason Pliml]

One option is to locate an ODBC driver for mySQL, then setup linked tables in Access.

The most recent version of Access I've used is 2000, so I can't really provide specific details beyond this.

Jason



To clarify - I want to keep the Access GUI, although not necessarily in Access.
i.e. I need forms, queries, reports, etc.
I'm not a php guru and I would prefer not to do it web based in this case.
That doesn't leave many options I think.
With the exception of DBACentral I mentioned before, I have not found any other solutions for this.
Of course I would prefer an open source solution.
Bill

kyle victor wrote: 
"Moving MS Access databases to MySQL server while keeping the GUI"?

Keep the Access GUI, or have a nice GUI for MySQL?

below is a GUI for MySQL i have used, and like very much

http://www.phpmyadmin.net/home_page/index.php




On 6/13/06, Bill Littlejohn <billl at mtd-inc.com> wrote:
  
Could someone give me a pointer for "Moving MS Access databases to MySQL server while keeping the GUI"? that's been brought up recently.

I need to rebuild an Access DB for use by multiple sites concurrently and have it pull data from an Oracle DB.
I don't want to use Access for a frontend if I can help it.

Google shows lots of options. http://microolap.com/products/database/mydbacentral/ looks promising for commercial.

A pointer in the right direction would be greatly appreciated.

Bill


_______________________________________________
grlug mailing list
grlug at grlug.org
http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug

    


  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://shinobu.grlug.org/pipermail/grlug/attachments/20060613/1d1d14cc/attachment-0001.htm