471,579 Members | 1,872 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,579 software developers and data experts.

Access, MyODBC, MySQL Questions .....

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

Mar 16 '06 #1
2 2562
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********@googlemail.com> wrote in message news:11**********************@i40g2000cwc.googlegr oups.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

Mar 21 '06 #2
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_TIMESTAMP 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

Mar 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Ryan Schefke | last post: by
3 posts views Thread by Steve Farber | last post: by
2 posts views Thread by Beda Christoph Hammerschmidt | last post: by
5 posts views Thread by csgraham74 | last post: by
49 posts views Thread by Mell via AccessMonster.com | last post: by
5 posts views Thread by kherse sefid | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by lumer26 | last post: by
reply views Thread by Vinnie | last post: by
1 post views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.