J
JHB
Hi:
I am running an application which was set up in Access 2000, under
Access 2007 AND Access 2010 in compatability mode. While I have had no
trouble with the Access 2000 version or the Access 2007 version, a
number of things seem different in Access 2010. Among other things,
the program does a number of loops (working through a table with
external querys). This is not an issue in 2000 and hasnt been one so
far in 2007. HOWEVER in 2010 the system throws up a message that I can
only loop 19 times and then hangs up!.
I need some way to get around thins (for example resetting the limit),
since changing the looping logic would be a massive undertaking. Does
any one have any idea how to do that either through VBA or through
setting some option in Access?
Help please -- we are stuck!
John Baker
I am running an application which was set up in Access 2000, under
Access 2007 AND Access 2010 in compatability mode. While I have had no
trouble with the Access 2000 version or the Access 2007 version, a
number of things seem different in Access 2010. Among other things,
the program does a number of loops (working through a table with
external querys). This is not an issue in 2000 and hasnt been one so
far in 2007. HOWEVER in 2010 the system throws up a message that I can
only loop 19 times and then hangs up!.
I need some way to get around thins (for example resetting the limit),
since changing the looping logic would be a massive undertaking. Does
any one have any idea how to do that either through VBA or through
setting some option in Access?
Help please -- we are stuck!
John Baker