Do you have a question? Post it now! No Registration Necessary. Now with pictures!
August 4, 2005, 9:18 am
rate this thread
possibilities of Access to retrieve, for example, for a definite
column, the values in a column of another table (through a SELECT....),
or determine a range of values that are allowed. Also I have always
copied & pasted similar records and then modified the pasted records.
All these procedures have sped up my work.
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).
If I keep on working in Access and I export everytime my database to
MySQL I have first to delete my tables in MySQL (that means that the
website is inactive for a while). I cannot make simple "Export only
Data" because I don't only add new records, but I update old records...
I mean, I have to make "insert" but also "replace". Which is the best
way to do it? Perhaps there is an easier way to do everything, or a
more efficient. I think I'm missing something.
Any help will be welcomed.
Re: From Access to MySQL
Linked tables suck - JET has no idea how to optimize queries. Use pass-thru
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