Hello,
I am using VB6 application (very old) with an Access 97 database.
The database is quite large (close to Access limit of 1G) and is used
over the network from multiple location.
[color=blue]
>From time to time when I am committing a large transaction (with[/color]
thousands of updates) the database gets corrupted.
I have tried most of the suggestions made by microsoft (close all one
recordsets when no longer needed, )
Does someone know of any problem on using large transactions with
Access databases or have any other ideeas?
Thanks
I am using VB6 application (very old) with an Access 97 database.
The database is quite large (close to Access limit of 1G) and is used
over the network from multiple location.
[color=blue]
>From time to time when I am committing a large transaction (with[/color]
thousands of updates) the database gets corrupted.
I have tried most of the suggestions made by microsoft (close all one
recordsets when no longer needed, )
Does someone know of any problem on using large transactions with
Access databases or have any other ideeas?
Thanks