Microsoft Access 2003 MDB - DSN Less connection to SQL Server 2000
I have 2 databases operating this way. 1 with no issues. The 2nd is generating an update on linked table failed - ODBC timeout expired. I have check the table but can find nothing that seems to be different. The form is a basic main form with subforms using the same record source. When I change a value on the subform and then move to the parent form the hourglass appears and then the timeout eventually appears. This same operation on the identical form in the 1st database has no problems.