Server supports MySQL but client records data in Access
Posted on 2003-03-11
I have another client who is ready to move to a new ISP for their Web hosting for various reasons. I am to choose an ISP for them based on their current and future needs, which are not extensive at the moment.
The ISP I am considering provides cPanel (Linux) with many features that the client would like to take advantage of e.g. phpBB Forum, Shopping Cart, php and MySQL ... just to name a few.
However, the most important aspect to consider re this client, is that they record some data inhouse using Access and would like this to be available for users to search only.
The problem in moving to the cPanel is that it does not, of course, support Access. The ISP suggests we go with their Windows2K Advanced package ... but it does not include many of the features the cPanel offers.
I work with Macintoshes and Dreamweaver etc and use Filemaker a little .... but cannot use Access. At the moment I am getting the client to save their small database file in Excel format and then converting this to several html pages so users can search.
Any other suggestions? I would appreciate any feedback or advice on the above.
Thanks very much, Sanengel