+ Reply to Thread
Results 1 to 2 of 2

Compact & Repair Backend Database

  1. #1
    Registered User
    Join Date
    04-29-2016
    Location
    Ocean Isle Beach, NC
    MS-Off Ver
    2010
    Posts
    35

    Compact & Repair Backend Database

    For those that develop Access databases for clients, do you provide instructions to your clients to compact and repair after your transfer the database over. I am new to developing databases for clients. Previously, I was onsite at the location where I developed a few database and would go and perform compact and repair once a month myself. I don't think my client will leave my access to his file server after the database is transferred.

    During the development of my current database, I have experienced issues with running compact and repair. I think the process couldn't delete the database file before renaming and saving the new compacted database so it renamed it from *.accdb to Database.mdb. I believe the issues was caused because the database was on Dropbox but I'm not positive.

    My instructions would be to make a copy of the backend before compacting and repairing should something go wrong but that may not sound very professional or comforting to a client. I appreciate any comments from the seasoned pros.

    Margaret

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    554

    Re: Compact & Repair Backend Database

    I generally use Excel as a front end for Access. The Access Db will have a table named something like 'AdminTbl' and will have a field that holds the last compact date. The Front End workbook will poll that field on open and if > some reasonable amount of time either prompt the user or automatically save a backup copy and kick off a compact and repair. I'm more of a fan of automatically kicking it off cos users generally don't read prompts.

    I've also used a file size check on the Db and if nearing 2Gb, automatically compact and repair.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filters blank and compact repair not working
    By grifter in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-25-2016, 04:08 PM
  2. split database MDE backend?
    By pjwhitfield in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-19-2014, 05:47 PM
  3. Excel Front end with backend database (Any database)
    By simba01 in forum Excel General
    Replies: 1
    Last Post: 08-16-2013, 10:58 AM
  4. Compact/Repair Access Database
    By pr4t3ek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2009, 04:41 AM
  5. Database backend to excel front end
    By Aidanb in forum Excel General
    Replies: 0
    Last Post: 08-27-2008, 09:18 AM
  6. Using Excel Sheets as a Database Backend
    By ADSK in forum Excel General
    Replies: 1
    Last Post: 12-04-2007, 05:52 PM
  7. compact MS Access while list box connected to database in spreadsheet
    By dim1ann@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2005, 05:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1