By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,471 Members | 1,466 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,471 IT Pros & Developers. It's quick & easy.

Database corrupt error while posting large transactions

P: n/a
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.
From time to time when I am committing a large transaction (with

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

Feb 24 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.