Yikes.... Access was not a very good relational database. Good for maybe 4 or 5 concurrent users. Maybe it has been improved since I used it 6 or 8 years ago.
If you are going to have to go through all that work why not just create an intranet?
Bryan O'Neal <
BONeal@cornerstonehome.com> wrote: You can connect to the Access DB using open office and ODBC on any
platform, but the Linux MS Access drivers all cost $$ while the windows
ones are free.
You will also need to rebuild all your forms and quires in OpenBase, but
it is very easy to link to the table information.
-----Original Message-----
From:
plug-discuss-bounces@lists.plug.phoenix.az.us
[
mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of
Craig White
Sent: Wednesday, September 05, 2007 4:44 PM
To: Main PLUG discussion list
Subject: Re: Access database conversion
On Wed, 2007-09-05 at 16:08 -0700, Carlton Brooks wrote:
> About 12 years ago I created an MS Access database for a historical
> society to maintain their collection of material.
> They would now like to make the information available on the 4 pc
units
> in their office instead of the one it is currently housed on.
> I thought that if I set up their server as a dual boot box, converted
> the access database to mysql, that they could run this as a local host
> from the web browser.
>
> First off is this feasible, second I have found software on
sourceforge
> to convert the access database to mysql. But the biggest hang up is in
> converting the forms and structure already created. Is there a program
> that will convert the forms and output data so that a minimal amount
of
> work is required to set it up.
----
The Windows version of openoffice.org is capable of opening/converting
the data into openoffice.org Base application - which then could use the
data from another SQL store like mysql.
--
Craig White
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
------------------------
Keith Smith
(480) 584-4772
PHP Programming
---------------------------------
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out. ---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)