Access is by nature a multi user database and their should be no reason
they four PC could not hit the same access file located on any standard
file server (Including a Linux smb server) However you need access on
all computers OR something that understands access.
If they are running windows based machines and the Access database is
form driven (you never have to manually open tables and query's) then
the other four machines could run off of this database using the free
(as in no cost) MS Access runtime.
If they are windows PC's or Linux boxes with a lot of work put into them
for web compatibility, and the database is nicely form based, and they
have an IIS 6 web server, you can host the database online.
Other then that the elegant solution depends on what kinds of clients
you plan to use. I am sure you had not intended to put them on command
line sql clients on no X nix boxes ;)
Rite now I sorta fail to see why you would need to convert or set up
duel booting. More information may be required to help solve this
problem
-----Original Message-----
From:
plug-discuss-bounces@lists.plug.phoenix.az.us
[
mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of
Carlton Brooks
Sent: Wednesday, September 05, 2007 4:09 PM
To:
plug-discuss@lists.plug.phoenix.az.us
Subject: Access database conversion
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.
Many thanks
Carlton Brooks
---------------------------------------------------
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
(text/plain)