RE: [PHP] Connecting to a MS Access database

Actually, I must put my .02 in again. ODBC is not by nature slow. Some implementations of ODBC are indeed slow, especially the ones that are additional abstraction layers on top of a native driver, but other ODBC drivers (OpenLink's included) can bypass the native networking layer, producing a connection that is as fast and in some cases far faster than the native driver. Not that the speed would be an issue with Access, though :) I agree fully with Geir - install a full-fledged multi-user database. If you are looking for another 'free' one, try Virtuoso http://www.openlinksw.com/virtuoso It is a fully functional SQL92 db and comes with a free 2 user license - enough to give you the same scalability as Access and you have the option of upgrading it's license later. It works quite well as a backend for PHP, and also lets you link other databases transparently through it (so you can access multiple database schemas as if they are a single local schema). Best regards, Andrew -------------------------------------- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com > -----Original Message----- > From: Geir Eivind Mork [mailto:geir.eivind@mork.as] > Sent: Monday, April 23, 2001 4:07 AM > To: Steve Maroney; Andrew Hill > Cc: Søren Soltveit; php-general@lists.php.net > Subject: Re: [PHP] Connecting to a MS Access database > > > On Sunday 22 April 2001 22:02, Steve Maroney wrote: > > This brings up a question that I always wondered. > > Does Access have server functionality? Where do you configure these > > settings ? > > If you go over the menuchoice - file, shake your mouse, bite in the cord, > slam your head in the monitor fifteen times and then trow a > bucket of water > over your computer a new option called 'server' comes up. if not, > repeat the > steps. > > Or install a database server. when using ex. asp towards an > accessbase it's > odbc that deals with the communication. it's slow, it's a > bottleneck.. but it > works :) > > > -- > php developer / CoreTrek AS | Thus spake the master programmer: > Sandnes / Rogaland / Norway | "After three days without > programming, > web: http://www.moijk.net/ | life becomes > meaningless." > -- Geoffrey >