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...