Re: Reserevd Error -7776 -- Urgent

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=NULL WHERE timestamp="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.