Posted by Jerry Stuckle on 09/05/05 08:51

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. It was
> suggested that I port to php and MySql. Having no experience with
> either, I'm wondering if this is a viable solution.
>
> The database if very "plain vanilla", i.e., bascially a flat file
> although a few tables with foreign keys relating to the main table. No
> fancy reporting just a few basic queries such as "show all systems
> marked as servers running version X of software Y" type of thing. Some
> of the forms have some VBA code behind them that do simple things like
> change the color of the text to make it stand-out. This data/web-page
> would only be used internally.
>
>>From what I've read so far, php looks like it may be a good way to go
> but I'm not sure. What say you all?
>
> Any suggestions, comments, concerns would be most welcome as well as
> pointers to sites that might be doing something similar.
>
> Bill W.
>
Bill,

PHP/MySQL is one tool you can use for this project. Is it the right
one? Only you can say for sure.

If you had MySQL and PHP experience, then I would say it probably is a
great tool. However, PHP is much different than MS Access and I think
you'll find not much will carry over except for the table definitions.

If you have other experience, i.e. .NET or .ASP, I might recommend you
also look into those as possibilities, with a SQL Server for the database.

But if you don't have any programming experience outside of Access,
probably most tools are as good (or bad) as the rest.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]