> I saw a note saying that the table needed both primary keys and a timestamp
> field for linked changes and I've tried this, but I must be missing
> something, since I can't get it to work for me. Can someone who is
> modifying data thru linked Access 2000 tables give me some specific
I had this exact same problem with Access 97. I had a primary key and
timestamp in my table and it still did not work.
After much investigation, I found out that when I compiled MySQL on a Linux
Mandrake 6.0 box, the timestamp comparision code was broken. So, I ended up
just installing the binary RPMs and everything works dandy now.
A way to check this is to insert something into your table, set the timestamp
to some time. Then do a SQL statement like "SELECT * WHERE
TIMESTAMP=001199102321" where the value is the actual value of the timestamp
in the table. If it comes back with that selection, then things are working
okay. If not, then something is broken.
* Ram Rajadhyaksha "There is nothing more conducive to panic *
* Inflection Technology Corp. than a no choice situation." - J. Jillson *
* <URL:mailto:ramr@stripped> <URL:http://www.inflectioncorp.com/ramr/> *