Search results

When all fails, use Microsoft suggestions. in the Code Section go to Tools>Analyze>Forms Select all and click OK Most likely you will get a message to use Option Explicit in most or all of the forms. That applies to Modules as well. Option Explicit makes sure that there are no conflicts or...

make sure that the tables in sql have indexes and keyes. I an into the same problem and that "cured" the malady. Also note that if there are any Bit data type fields in sql, they should be set to a default value (0 for NO/False and -1 to Yes/True) Access does not like null values for this type...