×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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!

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

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

VSS taking hours to check in MDB ?

VSS taking hours to check in MDB ?

VSS taking hours to check in MDB ?

(OP)
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/

RE: VSS taking hours to check in MDB ?

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.

RE: VSS taking hours to check in MDB ?

(OP)
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/

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

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! Already a Member? Login

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