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
>

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.

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

Your mileage may vary.

James Bailey

Computer Support

____________________________________________________________ _____________=
_
Enriching lives and minds by focusing on strengths and recovery
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--

Reserevd Error -7776 -- Urgent

Re: Reserevd Error -7776 -- Urgent