|
|
Posted by Colin McKinnon on 08/04/05 15:57
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.
Navigation:
[Reply to this message]
|