I've seen this mentioned a couple of times and still can't figure out the
answer.
I have a MySQL database table:
CREATE TABLE listings1199 (
ID mediumint(7) unsigned primary key,
START date not null,
END date not null,
EVENT varchar(80),
FAC varchar(80),
CITY varchar(50) not null,
STATE char(2) not null,
REG char(2) not null,
CODE varchar(30),
PRI tinyint(1) unsigned,
WWW varchar(100),
LAT int(10) unsigned not null,
LON int(10) unsigned not null,
INDEX (START),
INDEX (END),
INDEX (CITY),
INDEX (STATE),
INDEX (REG)
)
I populated this table with about 1000 records using MySQLimport.
I can create a linked table in Access 2000 which displays all the data in
the table and allows me to add a new record, but any change to an existing
records produces an error message saying that another user is accessing the
data and gives me an option to copy the data to the clipboard or abort the
changes.
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
directions?
Sanford Carr
