Access database conversion

[keith smith]

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 at 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 at lists.plug.phoenix.az.us
[mailto:plug-discuss-bounces at 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 at 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 at 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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20070905/6a329743/attachment.htm