Re: Copy database from MySQL to MSAccess

Hi Kjell I'm not sure whether you are transferring from within the webserver, or from the webserver to MS locally, but either way I'd set up the MS database locally. Just install the MySQL ODBC driver (I think its at the mysql.com website) and link all the MySQL tables to your MS Access database and just import the tables using the processes within Access itself. Afterwards you can transfer the Access database up to the server. If you are doing the database functions wholly within the server you might consider using the Pear DB database abstraction layer to make it simplier. (That's how I'd do it anyway). Cheers Leonie "Kjell Hansen" <kjell.hansen@saj.fi> wrote in message news:20030902054950.27750.qmail@pb1.pair.com... > Hi there, > I'd like to have a template DB stored with MySQL from which I later can > create clientDB's for use with MSAccess. > I've read that I can connect to MSAccess with PHP through ODBC and that's > fine but how do I transfer the tables and cusomized data? > > TIA > /Kjell Hansen