Re: Reserevd Error -7776 -- Urgent
| Newsgroups | gmane.comp.db.mysql.windows,gmane.comp.db.mysql.odbc,gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <OF99493DDA.F0C44972-ON85257149.00618D93-85257149.0061EB5B@unimin.com> |
"C K" <[email protected]> wrote on 04/07/2006 01:35:22 PM: > Dear Friends, > I have linked tables from MySQL through ODBC DSN in Access 2003. > when I go for updating any record in any linked table then it gives me > error as follows: > Reserved Error (-7776); there is no message for this error. > What will be the problem? Please help. > Is this error from MS ACCESS or for MySQL. > Thanks & Regards, > CPK > Have you read through this: http://dev.mysql.com/doc/refman/4.1/en/msaccess.html or this: http://dev.mysql.com/doc/refman/4.1/en/myodbc-with-vb.html or checked here: http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_JetDatabaseEngineVersion30ODBCConnectivity.asp (quoted)>>> -7776 SQLGetData(SQL_C_TIMESTAMP) Illegal date/time value returned. <<< My quick suggestion: Make sure that all of your timestamp and datetime fields are within their expected ranges. Sorry I can't be more helpful but it's a busy day here.... Shawn Green Database Administrator Unimin Corporation - Spruce Pine