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.
<br><br><p><DEFANGED_div><DEFANGED_span class="gmail_quote">On 6/13/06, <b class="gmail_sendername">Szymon Machajewski</b> <<a href="mailto:SMachaje@grcc.edu">SMachaje@grcc.edu</a>> wrote:</DEFANGED_span><blockquote class="gmail_quote" DEFANGED_style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
You have to separate GUI from the actual database (tables).<br><br>What I would suggest is moving the tables to MySQL and keeping the<br>Access GUI (forms, reports etc).<br>The easy way is to use a tool (like SQLYog) which allows you to export
<br>Access tables into MySQL server.<br><br>Once tables exist in MySQL server you simply connect via ODBC Access<br>(linked tables) to the MySQL server. So when you open Access your<br>tables will be from MySQL and GUI from Access. This way you can connect
<br>a number of thick clients (Access GUIs).<br>At the same time you can work on an alternative GUI. Maybe use PHP or<br>another language to provide online access to the database.<br><br><br><br><br>Szymon Machajewski<br>
<br>Solutions Engineer / DBA<br>Red Hat Certified Engineer<br>Microsoft Certified Solution Developer<br><a href="http://www.grcc.edu/smachaje">www.grcc.edu/smachaje</a><br><br><br>>>> <a href="mailto:billl@mtd-inc.com">
billl@mtd-inc.com</a> 6/13/2006 12:18 pm >>><br>Could someone give me a pointer for "Moving MS Access databases to<br>MySQL server while keeping the GUI"? that's been brought up recently.<br><br>I need to rebuild an Access DB for use by multiple sites concurrently
<br>and have it pull data from an Oracle DB.<br>I don't want to use Access for a frontend if I can help it.<br><br>Google shows lots of options.<br><a href="http://microolap.com/products/database/mydbacentral/">http://microolap.com/products/database/mydbacentral/
</a> looks promising<br>for commercial.<br><br>A pointer in the right direction would be greatly appreciated.<br><br>Bill<br><br><br>_______________________________________________<br>grlug mailing list<br><a href="mailto:grlug@grlug.org">
grlug@grlug.org</a><br><a href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a><br><br>_______________________________________________<br>grlug mailing list
<br><a href="mailto:grlug@grlug.org">grlug@grlug.org</a><br><a href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a><br></blockquote></p><DEFANGED_div><br>