Posted by Colin McKinnon on 09/05/05 11:29

Jerry Stuckle wrote:

> weissborn@charter.net wrote:
>> I have an application I have written in MS Access 2002. It is a very
>> basic inventory system for keeping track of information about our
>> Unix(solaris to be specific) servers. Other admins may want to use it
>> shortly and running MS Access over the WAN is no picnic.
<snip>
>
> PHP/MySQL is one tool you can use for this project. Is it the right
> one? Only you can say for sure.
>

The quickest solution would be to use a proper DBMS, attaching tables via
ODBC, if any forms/reports operates on joins then create queries set as
passthru SQL then use MS-Access (on a file share) as a front end. While I
like MySQL for web-based stuff, PostgreSQL might be a better backend of
this kind of setup.

HTH

C.

[Back to original message]