Cannot find what you need? - Click here to contact us

Close




Repairing a Microsoft Access database

If you are using the file database (Microsoft Access) and have any issues you can perform a compact and repair using any version of Microsoft Access from 2003 using the steps below.

If you are sharing the FILE database with over 10 users, or over an external network, the Internet, or other slow and none live links, or your file database is getting large, we do not recommend using the file database and you should use MSSQL or MySQL which are designed to be true network databases.


1, Start Microsoft Access

2, From the Tools menu, choose 'Database Utilities' > 'Compact and Repair'

3, From the file window that opens change the file type to 'All Files', and pick your Schedule it database file ending .SIP then choose Compact

4, At the save window change the file type to 'All Files', and rename your new repaired database from 'db1.mdb' to 'schedulit.sip' or any other SIP name you choose and pick the location you want to save it

5, You can now open the new SIP file with Schedule it from the File menu > 'Open Existing Database'


---------------

Common error messages repaired with file databases...

Error reading live dataset (6/6) - unrecognized database format 'File name'

Error reading cache dataset

select sValue from psettings where name = 'database'


Last updated, 27 October 2014, 14:06




Leave a reply (Login required)




Schedule it Ltd
/faq/10429/repairing-a-microsoft-access-database

Subscribe to our newsletter and receive our free scheduling tips and articles to help you improve the planning in your business. Unsubscribe anytime.

GET STARTED RESOURCES
Login Support and Help
Register Blog
Features Privacy Policy
Online Pricing Terms and Conditions
On-Prem Pricing Industry Sectors
Latest Version Reviews and Feedback
Live Webinar Status
APPS POPULAR SEARCHES
Web App Team Scheduling
iOS App Employee Planning
Android App Customer Scheduling
Zapier App Engineer Scheduling


Start Your Free Trial Today



Copyright © 2003-2022 Schedule it Ltd. All rights reserved.
Schedule it on LinkedIn   Schedule it on Twitter   Schedule it on YouTube   Schedule it on Facebook
Join Us - Live Webinar
...
 
Help Topics
Contact Us