Failing to update linked table

[perrymans]

ODBC --update on a linked table 'tblname' failed.

[Microsoft][ODBC Driver Manager] SQL data type out of range (#0)


I get this message whenever I try and update or change anything. I can't even open a table, delete a number 4, replace it with 4, and it still fails.

What causes this? I have a primary in every table (though they aren't called primary) and a timestamp in each table.

What am I missing?

Thanks. Sean.

 

[perrymans]

Bug 8363 at MySQl (bugs.mysql.com/bug.php?id=8363).

MyODBC driver 11-1 tranfers date fields into Access as text, not as dates. So since I had just put a timestamp field in each table, they were all failing.

I checked the table design in Access and it did show as test.

Unistalled 11-1, installed 11-2, now working great.

Next, I want to find a server on the web to try connections against.

Sean.

 

[loRdK]

Sean,

I've been experiencing the same problem and your report really helped me!

Thank you so much.

Ricardo