Debug a problem

[AlanM]

Environment: Access2000 Database running under on workstations that are running Access2003.

We have a routine that reads our database and updates email addresses to Outlook2003 Contacts on the workstations. (It's activated by a button in the Access application, so users can do it whenever they like).

Problem is that one, and just one, contact record is not being created correctly. The FirstName and Lastname fields are not coming accross and consequently the "display as" contact field is not properly populated either. The email address comes across OK.

The data in the Access application appears to be OK.

Any ideas how I can monitor/trace the Access routine during execution to see what's the cause of this problem please?

Thanks
AlanM

 

[RuralGuy]

Have you tried using Debug.Print to the Immediate window at various spots in your code?