[PHP] Re: Copy database from MySQL to MSAccess

2003-09-02 Thread Leonie
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

[PHP] Re: Copy database from MySQL to MSAccess

2003-09-02 Thread Kjell Hansen
Hi Leonie My approach is to have the empty AccessDB on the server. Make a copy of it and insert all the tables into the copy and then have it downloaded from the server. So I'm actually never gonna use Access, it's just the database I'm using for storage of data. One way of doing this could be to

Re: [PHP] Re: Copy database from MySQL to MSAccess

2003-09-02 Thread Dan Anderson
server. So I'm actually never gonna use Access, it's just the database I'm using for storage of data. Well ODBC implies that you are going to have a database program (i.e. Oracle, SQL Server, Access, whatever) to connect to. At least that's how I understand it to work. So if you don't have a