Re: From Access to MySQL

bettina@coaster.ch wrote:

> Now, if I work with PHPMyAdmin, I find that I lose the "overview" from
> Access, I cannot use these "SELECT" references and I cannot copy
> records. If I establish a link to my tables in MySQL from Access, so
> that I can keep on working in Access, the data entry will be slow and
> these references to another tables to retrieve data, are lost (they
> were not exported together with the database and I cannot re-create
> them because it is a "linked" table).

Linked tables suck - JET has no idea how to optimize queries. Use pass-thru
queries instead.

I often find it easier just to write the SQL by hand. If you really want to
do everything in MS-Access, IIRC it supports some offline replication
mechanism (requires an autoincrement field and timestamp field for each
table).

C.
Received on Mon Oct 24 02:09:15 2005