Smart Access Articles and sample files for the intermediate / advanced user Data Based Advisor The successor to Access / VBA / SQL Advisor – some good articles on Access for sale
FMS, Inc. World-class Access add-ins and utilities MZ Tools Great tools for editing in Visual Studio, Visual Studio, and VBA in Office. Black Moshannon Systems Speed Ferret search-and-replace utility Rick Fisher Consulting Another great Find and Replace utility SnagIt The best screen-capture and editing software.
Support Groups on Yahoo: MS Access Professionals Access Dev MS Access Microsoft Newsgroups Check out the Access and SQL Server newsgroups organized by topics. Answers by MVP designates (including me!) and other experts. Find Access under Desktop Applications and SQL Server under Servers. Utter Access forum Microsoft® Access, Excel, Word, Outlook®, Visual Basic®, SQL Server®, Office online help discussion… Read more »
http://www.fmsinc.com/tpapers/math/index.html Math calculation – a detailed white paper on math calculation problems in Access. http://support.microsoft.com?kbid=279334 Is your database hopelessly corrupted? Get help here (Access 97 version with links to 2000 and XP). http://support.microsoft.com?kbid=194374 Common functions not working (Format, Date, etc)? Get help here. http://support.microsoft.com?kbid=174217 DLLs not registering during a Runtime install? Get help here. http://support.microsoft.com?kbid=254372 Confused about Access Security? Get… Read more »
Access Team Blog All the latest news from the Microsoft Office Access development team. The Access Junkie Great tips from Jeff Conrad – the “Access Junkie.” FMS Home Page Lots of other goodies besides the white papers and utilities listed here in the links section. For Mere Mortals Check out other books in the Mere Mortals series here. MCW Technologies… Read more »
FixBroken.zip Code to “fix” a 2007 .accdb file that has been opened with 2010 or 2013 and one or more forms or reports edited. Editing a form or report in 2010 or 2013 potentially adds new controls that are not supported in 2007. Import the enclosed form into a backup of your “broken” database and follow the instructions to first… Read more »