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

Access 2000 corrupt data with huge jumps in autonumber

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.