Changing MS Access Attributes

[BulldogGC]

Can someone please help with how to change the attributes on a MS Access database so that it can be modified from the internet or on my intranet?

[drsenay]

Access was designed from the start as a single user, NON-Networked database to compete with FoxPro (which MS then bought) and drive users to SQLServer when they outgrew it... With some CAREFULL use, and A WHOLE bunch of custom code in VBA or Full blow VISUAL BASIC, you can get a great deal of INTRA-NET use out of it, anything more and youu really, really REALLY need an NT server, and then SQL server and so on... To USE it from the web, at the very least NT server, but really FULL NT/IIS/SQL Server to get anything serious done... Don't let it fool you my friend, ACCESS is a dead end street, why not try MySQL instead which does everything you want, and oh by the way, you can connect to it from Access and even export (using ODBC) from Access to MySQL...

Scott....

MySQL in use: http://www.partysite.com you can search 1.7 million records in under a second most of the time....

[BulldogGC]

Thanks for the soap box but this is a product designed for a client.
I do what they ask, they want PHP and MS Access for whatever odd reason ... not my problem.

The final product will be on an entire dc worth of IIS boxes ... I suggests MSSQL and VB.net but no dice.

So now I'm still left with the need for an answer to how to make PHP work with MS Access please.

Any help would be appreciated, thanks.