Reserevd Error -7776 -- Urgent

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

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Reserevd Error -7776 -- Urgent

------_=_NextPart_001_01C66CC7.2B725926
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

C K wrote:
> 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
> =20

MS Access does not like a timestamp of "0000-00-00 00:00:00" I always
forget that after I export a table and then link back to it after
creating the timestamp to make sure these are gone. =20

=20

Solution: UPDATE Table SET timestamp=3DNULL WHERE =
timestamp=3D"0000-00-00
00:00:00" ;

=20

Your mileage may vary.


James Bailey


Computer Support

=20



____________________________________________________________ _____________=
_
Enriching lives and minds by focusing on strengths and recovery=20
Mental Health Center of Denver- Winner of the 2005 Provider of =
Excellence Award from the National Council for Community Behavioral =
Healthcare.
CONFIDENTIALITY NOTICE: If you are not the intended recipient of this =
electronic message, you are hereby notified that any disclosure, =
copying, distribution, or action taken in reliance on the contents of =
this document is strictly prohibited.
If you received this information in error, please notify the sender =
immediately and arrange for the return or destruction of this document.

------_=_NextPart_001_01C66CC7.2B725926--