[GRLUG] Access->MySQL with GUI

[Jordan Hudson]

why not just use open office Base? its open source, and can create
everything your asking it to. I haven't used it much, and I'm nothing of a
database expert, but after learning access for 2 years (waste of my time =P)
I found Base to be very easy to adapt to.

On 6/13/06, Szymon Machajewski <SMachaje at grcc.edu> wrote:
>
> You have to separate GUI from the actual database (tables).
>
> What I would suggest is moving the tables to MySQL and keeping the
> Access GUI (forms, reports etc).
> The easy way is to use a tool (like SQLYog) which allows you to export
> Access tables into MySQL server.
>
> Once tables exist in MySQL server you simply connect via ODBC Access
> (linked tables) to the MySQL server.  So when you open Access your
> tables will be from MySQL and GUI from Access.  This way you can connect
> a number of thick clients (Access GUIs).
> At the same time you can work on an alternative GUI.  Maybe use PHP or
> another language to provide online access to the database.
>
>
>
>
> Szymon Machajewski
>
> Solutions Engineer / DBA
> Red Hat Certified Engineer
> Microsoft Certified Solution Developer
> www.grcc.edu/smachaje
>
>
> >>> billl at mtd-inc.com 6/13/2006 12:18 pm >>>
> 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
>
> _______________________________________________
> 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/20060614/5db1399d/attachment.htm