What This Book Covers
You migrated. It mostly works. But now things are breaking in unexpected ways — queries return wrong results, forms throw errors, reports look different, dates are wrong, and some features just stopped working.
This is the quick-reference troubleshooting guide you keep open on your desk during the first month after migration. Each of the 50 entries follows the same format: symptom, cause, fix. No theory, no background — just the answer.
Complete Table of Contents
- Part I: Connection and Data Issues
- Issue 1: Can't Connect to the Database Server
- Issue 2: Connection Drops During Use
- Issue 3: ODBC Driver Not Found or Wrong Version
- Issue 4: Authentication Failures
- Issue 5: "Too Many Connections" Errors
- Issue 6: Connection Works Locally but Not Remotely
- Issue 7: SSL/TLS Connection Errors
- Issue 8: Linked Table Shows #Deleted on Every Row
- Issue 9: Dates Displaying as 12/30/1899
- Issue 10: Yes/No Fields Showing Wrong Values
- Issue 11: Missing or Truncated Text Data
- Issue 12: Special Characters Displaying as Question Marks
- Issue 13: Currency Values with Wrong Decimal Places
- Issue 14: AutoNumber/Identity Gaps After Migration
- Issue 15: NULL vs. Empty String Behaving Differently
- Issue 16: Dates Off by One Day
- Issue 17: Large Text Fields Truncated
- Issue 18: Unicode Characters Lost or Corrupted
- Issue 19: Data That Passed Access Validation Rejected by Server
- Issue 20: Duplicate Records That Didn't Exist in Access
- Part II: Query, Form, and Report Issues
- Issue 21: Queries with Syntax Errors That Worked in Access
- Issue 22: Queries Returning Wrong Results
- Issue 23: Wildcard Searches Not Working
- Issue 24: Date Filters Not Matching Any Records
- Issue 25: GROUP BY Errors on Queries That Worked Before
- Issue 26: IIF Function Not Recognized
- Issue 27: NZ Function Not Recognized
- Issue 28: DLookup/DCount/DSum Not Working in Queries
- Issue 29: Crosstab Queries Completely Broken
- Issue 30: Queries Running Much Slower Than in Access
- Issue 31: Forms Loading Very Slowly
- Issue 32: Combo Boxes Taking Forever to Populate
- Issue 33: Can't Add New Records Through Forms
- Issue 34: Can't Edit Existing Records
- Issue 35: Subform Not Showing Related Records
- Issue 36: Record Navigation Sluggish
- Issue 37: Continuous Forms Performance Problems
- Issue 38: Form Filters Not Applying Correctly
- Issue 39: Required Field Validation Errors on Existing Data
- Issue 40: Multi-Select List Boxes Not Working
- Part III: Report, VBA, and Performance Issues
- Issue 41: Reports Showing Wrong Totals
- Issue 42: Reports Missing Records
- Issue 43: Subreports Not Loading or Very Slow
- Issue 44: Report Sorting Incorrect
- Issue 45: VBA SQL Strings Throwing Errors
- Issue 46: Connection Drops During Long VBA Operations
- Issue 47: Transaction Errors (Lock Timeout, Deadlock)
- Issue 48: Error Codes Changed — Can't Trap Errors Properly
- Issue 49: Recordset Operations Failing
- Issue 50: Everything Is Slower Than Access
- Appendices
- Appendix A: Quick-Reference Diagnostic Checklist
- Appendix B: Access Function to Server Function Mapping
- Appendix C: Connection String Quick Reference
- Appendix D: Emergency Rollback Procedure