Top tips for Access database management

A sluggish database can cost your money and waste users’ time. Here are some maintenance tasks and general best practices to ensure your database is healthy and operating at peak efficiency.

10+ ways to keep your Access database in tiptop shape

1: Compact

2: Use a simple and consistent design

3: Stick with standards and conventions

4: Document

5: Schedule backups

6: Defragment your hard disk

7: Split the database

8: Maintain a secure list of passwords

9: Audit users

10: Check connectivity

full list via techrepublic

10 tips for securing a Microsoft Access database

1: Check and reset settings using the AutoExec macro

2: Hide the Database window

3: Bypass the bypass

4: Split the database

5: Avoid Compact On Close

6: Hide objects — a subtle form of protection

7: Use error handling to protect code

8: Password-protect the database

9: Convert to mde or accde format

10: Password-protect the system

via techrepublic

5 Simple Tips to Prevent MS Access Database Corruption

1) Split your database.

2) Don't hold connections open.

3) Exit the database correctly.

4) Don't skimp on hardware.

5) Compact and repair regularly.

via kzsoftware