Application crashes upon trying to commit a transaction

[Ankit]

Hi,

I have a VC++ application which uses a MS Access DB. I use DAO classes
to carry out operations on the database. Off-late I have been
experiencing a crash (of the application) after trying to execute a
delete query. This happens only when the size of the DB reaches around
80MB to 1GB.

Any idea as to why this could happen? I have checked the code
thoroughly and it seems to be fine. Upon attaching a debugger, it shows
an 'Access Violation Error'. Does Access cause problems when the size
of the DB grows large?

Please let me know your suggestions/ideas.

Thanks a lot in advance.
Ankit

[downwitch]

Ankit wrote:

Hi,

I have a VC++ application which uses a MS Access DB. I use DAO classes
to carry out operations on the database. Off-late I have been
experiencing a crash (of the application) after trying to execute a
delete query. This happens only when the size of the DB reaches around

Any idea as to why this could happen? I have checked the code
thoroughly and it seems to be fine. Upon attaching a debugger, it shows
an 'Access Violation Error'. Does Access cause problems when the size
of the DB grows large?

Please let me know your suggestions/ideas.

Thanks a lot in advance.
Ankit
I hope you mean 80-100MB here:
80MB to 1GB

because otherwise that's a pretty huge size variation.

Approximately how many records are you trying to delete in the
transaction? Have you checked the MaxLocksPerFile setting in the
registry?

http://office.microsoft.com/en-us/as...321611033.aspx

[polite person]

On 22 Jul 2005 03:19:25 -0700, "Ankit" <an**********@gmail.com> wrote:

Hi,

I have a VC++ application which uses a MS Access DB. I use DAO classes
to carry out operations on the database. Off-late I have been
experiencing a crash (of the application) after trying to execute a
delete query. This happens only when the size of the DB reaches around
80MB to 1GB.

Any idea as to why this could happen? I have checked the code
thoroughly and it seems to be fine. Upon attaching a debugger, it shows
an 'Access Violation Error'. Does Access cause problems when the size
of the DB grows large?

Please let me know your suggestions/ideas.

Thanks a lot in advance.
Ankit

1. I think the Access (JET) limit is 2 Gbytes
2. the word "access" in your error message isn't Microsoft Access, this is a memory error
in your program but perhaps you knew this.

[Ankit]

Hey sorry for the typo, I indeed meant 80MB - 100 MB. The query usually
tries to delete approx 200 - 250 records.

[downwitch]

Oh right. Polite person is right, by the way, his #2 is very important
to understand--that's a Windows error.

And what I said doesn't apply for 200-250 records. The "access
violation" errors I was getting on my machine recently were indeed
caused by bad (hardware) memory, so I'd have another look at that
machine if I were you.

[Ankit]

Thanks for the advices.

I did know that the "Access Violation" were Windows errors and were not
related to MS Access DB in any way.

I have not been able to figure out a solution yet. Nevertheless, thanks
for all the help :)

Regards,
Ankit