Re: Opinions about php4 and MS Access

Hi Kevin, I havent used MSDE with Access, but as MSDE and MS SQL Server uses the same interfaces, I dont think Access can telle the difference. Access has an "upgrade" wizard you can use to export all data from the local access database to MSSQL Server (and to MSDE). If that works you can use MSDE as the backend to any Access application. If the wizard is unable to upzize the database to MSDE you should be able to export the structure and data and manually link the MSDE tables and views to access. - Frank >I'm aware of Accesses shortcomings, however, i can't just completely change >their operation (they have developed their own elaborate data entry system >for Access). Can I use MSDE with the current Access applications (GUI) that >they are currently using? > >Can I use MSDE to replicate or Mirror the Access DB? > >""Frank M. Kromann"" <fmk@swwwing.com> wrote in message >news:200011210146.CAA10694@swwwingsun... >> MS Access is not the database to use with mulitble reads and writes, it >hat no server task for handling i/o. You might use the same data structure >on a Microsoft Data Engine (MSDE) database. MSDE is a MS SQL server 70 >compatible database and it is free -:) With MSDE you can use the MSSQL >extension in PHP4. >> >> - Frank >> >> >I've got an upcoming client that currently uses an Access 2000 database. >> >They have spent all kinds of money (too bad for them) on creating a data >> >entry GUI for all of their employess to enter information into the >database, >> >so I really don't have flexibility on which db to use. >> > >> >The server is going to be NT 4. I'm going to have full control of the >> >server, and as I've found php the coolest thing (and way more fun than >ASP), >> >I'm seriously considering using it on this project. >> > >> >I guess what I'm looking for is some kind of reaction or objection to >> >utilizing PHP with Access, or if theres a cool workaround (I'd even like >it >> >if anyones used a method of sharing current data with an Access db and >> >another db). >> > >> >Any kind of comments on reliability of the match (PHP and Access) and >also >> >any information on replicating or mirroring databases would be greatly >> >appreciated. >> > >> >phool >> >kevin@vcconcepts.com >> > >> > >> > >> >-- >> >PHP Windows Mailing List (http://www.php.net/) >> >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> >For additional commands, e-mail: php-windows-help@lists.php.net >> >To contact the list administrators, e-mail: php-list-admin@lists.php.net >> > >> > >> > >> >> >> >> >> -- >> PHP Windows Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> For additional commands, e-mail: php-windows-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> > > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >