Access crashes with SQL Server backend

C

cbender

I have a rather baffling problem with an Access database application I
am trying to migrate to use a SQL Server backend (via ODBC). The
application is working fine using the Access tables, but when I
connect up to a SQL Server database (2000 or 2005 doesn't seem to
matter) I start getting Application errors (Access closes).

This did not happen when I initially tested this back in August 2006,
but now even the version I created then exhibits the same behavior. I
have tried this both on an SP1 and SP2 installation and am quite
baffled.

I have also tried importing all of the objects into a new database.
This does not exhibit the typical behavior of a corrupt Access form
that will always crash for instance when you click a certain button or
select a control. Rather it seems to crash on queries that update the
SQL tables. Also, when I trace into the code to try to isolate the
query it does NOT crash, but then if I just let the procedure run it
crashes every time. Does anyone have any suggestion on how to further
isolate this problem?

Thanks
Cheryl
 
Top