I have a vb.net application reading an oracle database and writing to an Access Database .
I have two sets of Tables , So I was using two instances of the same application to insert ( One instance to insert one set of tables and another instance to insert the second set)
The problem is , Access file size increases over 2 GB ( In fact if I use one instance of EXE to insert all the tables , I never come thru this issue ) .
How can I solve this ?
Is there really a restriction on Access preventing insert into two tables at same time ?
(Also out of curiosity , is this same for updating tables also)