Yes, each record has a primary key, but not a timestamp. Does this make any
difference?
This also happens with my Unix machine which has MySQL installed on it. I
have had the problem for about a year, but now that I'm starting to use
MySQL in real-time applications I'm developing at work, this is a real bug
bear and one that I'm surprised no one knows about.
Thanks,
Kevin
----- Original Message -----
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 10:30 PM
Subject: Re: MyODBC 2.50.37 and Access 2000
> 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> Joshua Kugler, Information Services Director
> Associated Students of the University of Alaska Fairbanks
> [EMAIL PROTECTED], 907-474-7601
>
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
