Tony's Microsoft Access Tips

Most accessed tips pages

• Microsoft Access based (or similar) Accounting Systems
• Microsoft Access Email FAQ (Frequently Asked Questions)
• Corrupt Microsoft Access MDBs FAQ
• Deleted Records or Deleted Tables
• Best practices My very subjective list of things you should always do.
• Tony's Table and Field Naming Conventions
• Tony's Object Naming Conventions
• Microsoft Access Performance FAQ
• Ultra Frequent Application Deployment
• Microsoft Access Developer Edition FAQ  

Tips pages

• Help System Tips
• Copy protection or how to safely distribute a demo Access Application
• Faxing from Microsoft Access to Winfax Pro
• Add-in Tips, Hints and Gotchas
• Report Printing Criteria Selection Form
• Microsoft Access and the Year 2000
• Create Families from Volunteers User Interface (Treeview example)
• Microsoft Access ODE or MOD Runtime Problems
• Verify Appropriate Jet Service Pack is installed
• Why would you want to upsize to SQL Server?
• My random thoughts on SQL Server Upsizing from Microsoft Access
• My random thoughts on Microsoft Access, Terminal Server and/or Citrix
• Late Binding
• Using bar codes within an application
• TCP/IP programming
• Bloating Front End (FE) Microsoft Access MDB/MDEs
• Image Handling
• Miscellaneous Access Tips Bits of code and other little oddities nothing worth putting on their own page.
      - Allowing the user to efficiently use percentage fields
      - Sorting a report on demand
      - Progress Bar
      - Resume while debugging
      - How do I maximize the report preview after it's opened?
• One method of using SQL queries in code as parameter queries can be difficult to work with in code
• Splitting your app into a front end and back end
• Create an MDB from an MDE. You can't
• Sending reminders, be they weekly, monthly, paper, snail mail or email
• Backup, do you trust the users or sysadmins?
• How to effectively run multiple versions of Access on the system
• The TempTables.MDB illustrates how to use a temporary MDB in your Microsoft Access app.
• Calendars
• Reading text (.txt) files from with Microsoft Access
• Updating an Access Backend MDBs structure using VBA code
• Access 2.0 and Access 97 to Access 2000/2002 conversion issues/problems/bugs
• Form, Report, Module Object Usage Statistics
• Microsoft Access Reports and Dot Matrix Printers
• Timberline ADO Connection String   
• How to get rid of troublesome references  
• Progress Bars 
• I have an intense dislike for cascade deletes in Microsoft Access.  And I don't like cascade updates.   
• Currentdb.RecordsAffected Property in Microsoft Access   
• Positioning on a continuous form after deleting a record 
• Locking fields on a form 
• If an index is a duplicate of another index then Access/Jet does not take any extra space.
• Setting Startup Options Programmatically in Microsoft Access  
• Tracking users entering and exiting Microsoft Access Front Ends
• Shifting fields left on a continuous form  
• Using data from the previous year    
• Microsoft Access Compatible Compression Solutions
• Relinking Tables   (2008-06-30)
• Referencing a control on a subform from the parent form in Microsoft Access VBA  (2008-08-25)
• NotInList event in combo boxes    (2008-11-30)
• Idle Detect/Inactivity Timeout >  (2010-09-03)

Troubleshooting and errors

• /Decompile or how to reduce MDB/MDE size and decrease start-up times
• Screen shots of error messages
• Reserved Error (-1517) in Microsoft Access
• Out of MS-DOS file handles - error 3042
• Unexpected Error (40230) in Microsoft Access
• Office XP MOD/Access 2002 runtime can't install on Windows 2003 Server
• Unexpected Error (32811) in Microsoft Access 
• DSN Less Connections and Weird ODBC problems     
• An unexpected error occurred Number -2147319779
  Description: Method 'Fullpath' of object 'Reference' failed.
• "MSysAccessObjects" or "MSysAccessStorage" is already opened exclusively
• The database engine couldn't lock table '<table name>' because it's already in use by another person or process.

[ Access | Main ]

   Auto FE Updater New unzip ZIP files including subfolders  The Enterprise Edition -  send emails to all users or just the users currently in the backend database file.

Granite Fleet Manager - the best designed fleet maintenance tracking and management system available