Bug/limitation with VB3.0 / Access 2.0 compatability layer 
Author Message
 Bug/limitation with VB3.0 / Access 2.0 compatability layer

  I'm doing some testing with the comp. layer program. My database was
created and populated as an Access 1.1 db. I converted it to 2.0 using
Access 2.0. I then installed the comp. layer program on my PC.
(Standalone). Now, when I run my program which uses "BeginTrans" and
"Committrans", it get the error msg: "Too many tables open". In between
the "BeginTrans" and "Committrans", I have a loop which reads a rec in
from a flat file, opens a snapshot to pull out some values and then close
the snapshot right away. This code worked fine before the layer install
but now it doesn't seem to be closing the table anymore. It processes 331
recs from the flat file before kicking out with the above error msg.
(meaning it also had open & closed the dynaset 331 times.)

When I run the exact program on a PC without the compat. layer installed,
it works fine.

Any ideas ??


Sat, 14 Feb 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

2. Access 2.0 compatability layer

3. Access 2.0 Compatability Layer Setup Problems

4. Access 2.0 Compatability Layer Setup Problems

5. VB3 - Access 2.0 Compat Layer compact problem

6. changinf tabledef on access 2.0 database using vb3.0 pro and comp layer

7. Install Access 2.0 Cmpt Layer w/o Access 2.0 for VB 3.0

8. Can't Install 2.0 compatibility layer without Access 2.0

9. VB 3.0, Compatability Layer, and Access Service Pack Question

10. VB 3.0/MS Access 2.0 Compatability Question

11. I need the Access 2.0 to implement the Compatibility Layer

12. Help for VB to Access 2.0 compatibility layer.


Powered by phpBB® Forum Software