ODBC Connection failure

Hello there!

This is my issue: I do have a database which back end is in SQL Server 2005 and front end is in ACCESS 2003. When one of the forms is trying to write duplicate information in any of the tables, there is a message coming "ODBC -- call failure", I wrote code trying to avoid that situation, but is keeps on coming. Does anybody have any idea about how to handle this exception? I would really appreciate a help on this subject.

Thanks;

Luisofo

One approach is to add an On Error handler to the Access Form. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac11/html/achowRuntimeErrorHandling_HV05186924.asp In the On Error handler you can use the Err object to determine the source of the error and provide useful information to the user to correct the problem.

If you are ok with duplicates in the table (not usually the situation) you can remove the constraints on the SQLServer 2005 datgbase tables.

HTH.

sql