By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Access, MyODBC, MySQL Questions .....

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.