If you set your DATE types to NOT NULL you need to set the default to an
actual date ACCESS can't deal with '0000-00-00' which is what MySQL will set
a DATE type to if it the date it is passed is invalid. By setting the
column to NOT NULL you essentially force a date of '0000-00-00' when that
column is empty.
Set any DATE type columns to default to a known valid date that you can
identify in your application. I use epoch '1970-01-01' or my birthdate.
eg.
regdate DATE NOT NULL DEFAULT='1970-01-01'
I hope this helps.
Pat...
----- Original Message -----
From: Sanford Carr <spcarr@stripped>
To: <myodbc@stripped>
Sent: Thursday, November 04, 1999 1:21 PM
Subject: Access 2000 - user already updating record
> 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
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread856@stripped>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
>
>

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.