Access, MyODBC, MySQL Questions .....

[David]

Hi,

Has anyone had this problem ?

I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11
standard log.
I created my tables in MS Access, then exported them via ODBC to an
externally hosted MySQL database (fasthosts) . I then import-linked
them back into my MS Access database.
Before I import linked them back, I edited the tables in MySQL so that
the PK & Autonumber was set and added a timestamp field.

The problem I seem to have is that when I use the Timestamp field in
MySQL, I cannot seem to update current records on my Access forms
without getting the error 'Reserved Error (-7776)'. If I remove the
Timestamp field, the error goes away, but then I get the usual #Deleted
problem when adding records etc.

I know the timestamp is required, but I cannot seem to get arround this
unknown error ?

Appreciate your help.

Thanks

David

[Malcolm Cook]

David,

I'm using Access 2002 (10.6501.6714) SP3 against MySQL ODBC Driver v3.51 AGAINST MySQL 4.0.18

I found that I had to add the timestamp and have a primary key to update without getting #Deleted.

I'm not going to update my MySQL isntall, but, testing with Access 2003 (11.0.5614.0) all works fine (with the timestamp and the
primary key).

Make sure your timestamps have values. It seems that adding a timestamp does not undersome circumstances give the field a value.
You can simply issue something like this to get a value assisgned to your timestamps automagically:

update mytable set somefield = somefield

(assuming somefield is a column in mytable)

see http://forums.mysql.com/read.php?65,14085,14085 for some other discussion on this

--
Malcolm Cook
Stowers Institute for Medical Research - Kansas City, MO USA
"David" <go********@goo glemail.com> wrote in message news:11******** **************@ i40g2000cwc.goo glegroups.com.. .

Hi,

Has anyone had this problem ?

I am using MySQL ODBC 3.51 Driver, with MS Access 2003 and MySQL 4.1.11
standard log.
I created my tables in MS Access, then exported them via ODBC to an
externally hosted MySQL database (fasthosts) . I then import-linked
them back into my MS Access database.
Before I import linked them back, I edited the tables in MySQL so that
the PK & Autonumber was set and added a timestamp field.

The problem I seem to have is that when I use the Timestamp field in
MySQL, I cannot seem to update current records on my Access forms
without getting the error 'Reserved Error (-7776)'. If I remove the
Timestamp field, the error goes away, but then I get the usual #Deleted
problem when adding records etc.

I know the timestamp is required, but I cannot seem to get arround this
unknown error ?

Appreciate your help.

Thanks

David

[Bri]

Malcolm Cook wrote:

Make sure your timestamps have values. It seems that adding a
timestamp does not undersome circumstances give the field a value.

Set the Timestamp field default value to CURRENT_TIMESTA MP and it will
store the current date/time in the field. This is different than the SQL
Server Timestamp field which automatically stores a binery
representation of the current date/time that is not user usable.

--
Bri