MSAccess database grows from 47K to 1,600K for no reason

[cpow]

The database will be working fine and all of a sudden for no apparent
reason when I am trying to add a record to the MSAcesss 2000 database I
get an error message that simply says "MSACESS ERROR" and it grows from
47K to 1,600K and corrupts the data to where it can't be repaired or
recreated. I lose everything.

I do keep backups but this is becoming a real problem in my life. Does
anyone else have thie problem and if so what was the cause of the
problem.

Thanks
Tex

[cpow]

cpow wrote:

The database will be working fine and all of a sudden for no apparent
reason when I am trying to add a record to the MSAcesss 2000 database I
get an error message that simply says "MSACESS ERROR" and it grows from
47K to 1,600K and corrupts the data to where it can't be repaired or
recreated. I lose everything.

I do keep backups but this is becoming a real problem in my life. Does
anyone else have thie problem and if so what was the cause of the
problem.

Thanks
Tex

P.S. -- Also scanned with Norton Antivirus and the computer is clean

[ManningFan]

I'd put a toggle on the "add record" function that's causing the
problem that allows you to step into the code. It's got to be doing
something funky for that to happen because it's surely not normal. You
may find it's launching something that it shouldn't.

cpow wrote:

cpow wrote:

The database will be working fine and all of a sudden for no apparent
reason when I am trying to add a record to the MSAcesss 2000 database I
get an error message that simply says "MSACESS ERROR" and it grows from
47K to 1,600K and corrupts the data to where it can't be repaired or
recreated. I lose everything.

I do keep backups but this is becoming a real problem in my life. Does
anyone else have thie problem and if so what was the cause of the
problem.

Thanks
Tex

P.S. -- Also scanned with Norton Antivirus and the computer is clean

[MarcHG]

cpow,

I cannot guess the real reason of this error because it can be anything
when the hardware-platform isn't operating well. (memory-errors,
network-errors, disk-errors etc.). The only case I experienced a
similar problem with proper hardware (but not to this extreme) I could
get rid of it by updating Access 2000 (with officeupdate) and the Jet
engine to the latest and proper levels of both product-sets. In my case
the regular more moderate but also alarming fast growth of the mdb-file
with each updated record ended after this. The components sometimes are
out of sync a little because the Jet-engine modules became part of the
windows productset and installing older versions of Access on more
modern versions of the Windows OS can lead to slightly incompatible
modules handling mdb file formats.

Marc

cpow schreef:

cpow wrote:

The database will be working fine and all of a sudden for no apparent
reason when I am trying to add a record to the MSAcesss 2000 database I
get an error message that simply says "MSACESS ERROR" and it grows from
47K to 1,600K and corrupts the data to where it can't be repaired or
recreated. I lose everything.

I do keep backups but this is becoming a real problem in my life. Does
anyone else have thie problem and if so what was the cause of the
problem.

Thanks
Tex

P.S. -- Also scanned with Norton Antivirus and the computer is clean