<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks for everyones suggestions.<br>
I've decided to go with DBACentral for a few reasons.<br>
Low cost ($125).<br>
It will convert my Access DB tables and queries to MySQL, and provides
a runtime version including 5 users that displays the converted Forms.
Since my target users are all using Windows this is ideal for
performance reasons and getting running quickly. I plan to run MySQL 5
on OpenSUSE 10.1 for the backend.<br>
DBACentral can also generate PHP pages for the forms, which would allow
me to migrate later on to a completely standardized and open platform.<br>
<br>
For my purposes in this project, OOBase would not be ideal since it
requires the full install of OO.<br>
(I really wish they would split the apps up)<br>
I would really love to hear of anyones success in converting a complete
DB to OOBase however.<br>
<br>
Bill<br>
<br>
<br>
Szymon Machajewski wrote:
<blockquote cite="mid448FC908.E45E.0054.0@grcc.edu" type="cite">
<pre wrap="">I've had hard time importing Access database into OOBase. I can link
the database to Access file easily, but I want to 'convert' Access
database to OOBase. Any idea how to do that?
Re-creating is what I'm trying to avoid.
Szymon Machajewski
Solutions Engineer / DBA
Red Hat Certified Engineer
Microsoft Certified Solution Developer
<a class="moz-txt-link-abbreviated" href="http://www.grcc.edu/smachaje">www.grcc.edu/smachaje</a>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:jodanlime@gmail.com">jodanlime@gmail.com</a> 6/14/2006 1:18:31 am >>>
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap=""><!---->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 <a class="moz-txt-link-rfc2396E" href="mailto:SMachaje@grcc.edu"><SMachaje@grcc.edu></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->export
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->connect
</pre>
<blockquote type="cite">
<pre wrap="">a number of thick clients (Access GUIs).
At the same time you can work on an alternative GUI. Maybe use PHP
</pre>
</blockquote>
<pre wrap=""><!---->or
</pre>
<blockquote type="cite">
<pre wrap="">another language to provide online access to the database.
Szymon Machajewski
Solutions Engineer / DBA
Red Hat Certified Engineer
Microsoft Certified Solution Developer
<a class="moz-txt-link-abbreviated" href="http://www.grcc.edu/smachaje">www.grcc.edu/smachaje</a>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:billl@mtd-inc.com">billl@mtd-inc.com</a> 6/13/2006 12:18 pm >>>
</pre>
</blockquote>
</blockquote>
</blockquote>
<pre wrap="">Could someone give me a pointer for "Moving MS Access databases to
MySQL server while keeping the GUI"? that's been brought up
</pre>
</blockquote>
<pre wrap=""><!---->recently.
</pre>
<blockquote type="cite">
<pre wrap="">I need to rebuild an Access DB for use by multiple sites
</pre>
</blockquote>
<pre wrap=""><!---->concurrently
</pre>
<blockquote type="cite">
<pre wrap="">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.
<a class="moz-txt-link-freetext" href="http://microolap.com/products/database/mydbacentral/">http://microolap.com/products/database/mydbacentral/</a> looks promising
for commercial.
A pointer in the right direction would be greatly appreciated.
Bill
_______________________________________________
grlug mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grlug@grlug.org">grlug@grlug.org</a>
<a class="moz-txt-link-freetext" href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a>
_______________________________________________
grlug mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grlug@grlug.org">grlug@grlug.org</a>
<a class="moz-txt-link-freetext" href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a>
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
grlug mailing list
<a class="moz-txt-link-abbreviated" href="mailto:grlug@grlug.org">grlug@grlug.org</a>
<a class="moz-txt-link-freetext" href="http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug">http://shinobu.grlug.org/cgi-bin/mailman/listinfo/grlug</a>
</pre>
</blockquote>
<br>
</body>
</html>