Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Over the past year I have found your site to be EXCELLENT. Never have I been able to find so many answers to such vast problems and it is an excellent service..."

Geography

Where in the world do Tek-Tips members come from?
groleau (Programmer)
14 May 07 14:23
We do not yet have Office 2003, and so we can check in
Access components as text files.

So I have been checking in/out whole databases instead.

About a week ago, and ever since, checking in a DB with
"keep checked out" enabled takes hours.  (Formarly took
less than five minutes worst case.  Eventually completes,
but it's weird.

During the time it is showing an hourglass, some
applications have trouble launching, but interestingly,
the non-local disk that holds both the VSS database and
the MDB being processed is no slower than normal.

--
Wes Groleau
http://www.Parkview.com/

Aptitude (Programmer)
15 May 07 5:16
How big is the MDB file? I once had this years ago after I had been doing lots of deletes and inserts in the database. It turned out the database had expanded to nearly 1Gb. This is caused because access never actually deletes anything it just marks the record as deleted instead. You may need to "Compact" the database to get rid of such records.
groleau (Programmer)
15 May 07 10:16
I always have databases compact on close.
The one that I killed this morning (after
it failed to complete all night) is pretty
big, but it has done this on smaller ones.

--
Wes Groleau
http://www.Parkview.com/

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close