Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Micron,

    Code:
    Is your db split? I don't see where you've clarified this. Code to detect a split, single user front end will always show it's in use, won't it? That can include the back end as well. If a FE has a connection, the BE is in use, even in a split db. Don't see how that's useful. A count of logged in users (from a user table) would tell you if there's any more than 1. AFAIK, there will always be at least regardless if it's split or not. I would not rely on the locked db file either (ldb in 2007).
    i have tested it. If i had opened the back-end or front-end the file was locked and function returned true. If i went out - the function was false. So it is working.

    Code:
    The compact was only done if the file size exceeded the threshold. 
    I often use task sheduler also. How can you set up detecting if file size exceed the treshold in order to do compacting?

    Thank you for your help!


    Jacek

  2. #17
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    For me, TS was for backing up, not for compacting. You're wanting to compact when closing when nobody else is in. I know of no way to do this with TS but I suppose it would be possible in a round about way.

  3. #18
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Thank you Micron very much !

    Best Wishes,
    Jacek

  4. #19
    Micron is offline Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You're welcome.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Compact thesize of MS Access Database
    By kacocal in forum Import/Export Data
    Replies: 3
    Last Post: 03-06-2016, 04:25 AM
  2. Split Database | Compact and Repair
    By mrmmickle1 in forum Access
    Replies: 4
    Last Post: 07-27-2015, 08:53 AM
  3. Unable able to compact BE Database
    By crowegreg in forum Access
    Replies: 3
    Last Post: 01-30-2014, 09:02 AM
  4. Replies: 7
    Last Post: 11-11-2010, 11:16 AM
  5. Compact/Reapir doe not reduce database size
    By nosrepmodnar in forum Access
    Replies: 1
    Last Post: 10-23-2009, 02:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums