Results 1 to 4 of 4
  1. #1
    dollygg is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    73

    Archive and Compact function

    My MDB file is 200MB after compacting. Is there anyway to compact the file further other than moving old records somwwhere else?

  2. #2
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    Is your database split between front end and back end?

    If so, you can further split your back end into seperate ones and link each one accordingly. A thought on this subject is to split it between tables that are changed regular and table that are primarily used as look up tables.

    David

  3. #3
    dollygg is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2009
    Posts
    73

    how to call a sub procedure from other forms

    ON the import form, the following code had syntax problem:
    Call Forms!ReconForm!SetRecon

    (SetReocn is a sub procedure in the ReconForm!, Can I use the run function?)

  4. #4
    dcrake's Avatar
    dcrake is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    435
    You just need to code

    Call SetRecon if the form is open and is the active form.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Automate Compact and Repair process
    By tracerbullet in forum Security
    Replies: 2
    Last Post: 01-14-2010, 05:12 PM
  2. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 AM
  3. MS Access compact problem
    By chiru_ongole in forum Access
    Replies: 5
    Last Post: 08-01-2009, 06:53 AM
  4. MS-Access 2007 - Compact & Repair how?
    By techexpressinc in forum Access
    Replies: 2
    Last Post: 03-05-2009, 02:12 PM
  5. Archive data
    By markhook in forum Forms
    Replies: 0
    Last Post: 08-08-2006, 10:23 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