Hi Alain.
No - I believe you got my question right <smile>.
I *think* I understand what you suggest:
-for each record in the access table
+delete the corresponding one in the mysql-table
+insert the access-record into the mysql-table.
Is that how you ment it? Anyway - this looks like a nice idea. But
(there is always a but :) I need to entirely replace the old mysql
table with a new one (the access-table) - I can't leave any "old"
records in the new table. I guess this can be done by first wiping out
every record in the mysql table and the do insert's from Access (using
ODBC)?
Let me know if I got _you_ wrong <smile>
Best Regards /Anders
=========================================================
On Tue, 16 Nov 1999 16:00:43 +0100, Alain Fontaine wrote:
Hello,
How about this: create a couple of update queries, or "delete and
insert"
pair queries, in Access, and use ODBC to directly update your mySQL
tables?
You shouldn't need to recreate indexes and "not null" stuff as the
mySQL
table definition and structure will never alter; the only thing that
will
alter is its contents.
Maybe I got your question wrong... ? ;)
>win32@stripped
--
Anders Engström
GIS-Centrum, Lund
0709-62 07 73
=============================
Your mind's like an umbrella.
It doesn't work unless you open it.
/Frank Zappa
