This may be a silly question, but since you didn't state it in your e-mail:
does each record have a primary key AND a timestamp field?
j----- k-----
On Friday 13 July 2001 01:24, Kevin Smith wrote:
> Hi All,
>
> I've installed MySQL 3.23.39 on my Windows 2000 Pro Server and I am
> currently developing a database using Access 2000 as a front-end to MySQL
> using MyODBC 2.50.37.
>
> I have all my MySQL tables linked as ODBC tables in Access.
>
> When I am inputting data into an Access Form and then save the record, all
> the fields are changed to #DELETED. The record data is saved I know, but
> why do the fields all change to #DELETED when the record is inserted into
> the MySQL table? Is there a fix for this, or, it is just the case of using
> ADO to do the insert and just refresh the Access Form to then move to the
> record itself... a bit of a pain though...
>
> Any ideas?
>
> Many thanks,
>
> Kevin Smith
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread79347@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-isd=as.uaf.edu@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
isd@stripped, 907-474-7601
