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

Compact and repair causing record locks

P: n/a
I have recently started to do more regular compact and repair's on one
of our larger databases, and I have started to notice a problem ever
since starting the compact and repairs record locks have become much
more frequent, ne ideas?

DB: MS ACCESS 2000
USERS: 4- 8
SIZE: 300 MB
WIN: WINXP SP2

Sep 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"nexes" <ne******@gmail.comwrote in
news:11**********************@e3g2000cwe.googlegro ups.com:
I have recently started to do more regular compact and repair's on
one of our larger databases, and I have started to notice a
problem ever since starting the compact and repairs record locks
have become much more frequent, ne ideas?
Are people likely to be working on newer records? This might be
exactly the kind of situation where a random autonumber PK might
help, as it will end up with recent and old records distributed over
all the data pages of both the indexes and the data.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Sep 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.