Access 2000 corrupt data with huge jumps in autonumber

[j.mandala]

I have recently received a few calls from people using a split
database I developed, reporting that data get corrupt and unreadable,
or records 'disappear'. I am not sure that all the porblems are
related, but the damage can sometimes be traced to a table that has
two memo fields in it. The problems often begin on a particular day
when the autonumber field for that table with suddenly jump up from
something like 5000 to 1 million or so. I recently looked at a table
where this happened twice, the second time jumping in to the 10
millions...

The machines are fairly new, running Windows XP or Windows 2000.

[SA]

J.

you don't indicate which version of Access you are running, but there were
some problems like this in A2K which were solved with service releases and
Jet engine updates. Make sure you have installed all the latest updates.

Secondly, when you get db corruption repeatedly like that you may also want
to look at network issues. Dropped connections in the middle of a write
operation will quickly corrupt a Jet db. This could be due to a NIC, router
or hub that's bad.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"j.mandala" <ma*****@rci.rutgers.edu> wrote in message
news:6c**************************@posting.google.c om...

I have recently received a few calls from people using a split
database I developed, reporting that data get corrupt and unreadable,
or records 'disappear'. I am not sure that all the porblems are
related, but the damage can sometimes be traced to a table that has
two memo fields in it. The problems often begin on a particular day
when the autonumber field for that table with suddenly jump up from
something like 5000 to 1 million or so. I recently looked at a table
where this happened twice, the second time jumping in to the 10
millions...

The machines are fairly new, running Windows XP or Windows 2000.

[j.mandala]

Thanks for the speedy reply. The person I spoke to yesterday had
Access 2000 SP3 running on all the machines. Does that also mean the
Jet engine is updated?

Jim Mandala

J.

you don't indicate which version of Access you are running, but there were
some problems like this in A2K which were solved with service releases and
Jet engine updates. Make sure you have installed all the latest updates.

Secondly, when you get db corruption repeatedly like that you may also want
to look at network issues. Dropped connections in the middle of a write
operation will quickly corrupt a Jet db. This could be due to a NIC, router
or hub that's bad.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg