Access Junkie

Access FAQ, articles and even online training. A great site for information for Access 2010 and 2007.
  Access Runtime Microsoft’s royalty-free runtime for Access 2010
  Access Team Blog Your outlet for keeping abreast of what’s taking place in the world of Microsoft Office Access directly from the members of the Access Team.
  Compatibility Between 32-bit and 64-bit Access With the intro of the 64-bit version of Microsoft Office 2010, a new version of Microsoft Visual Basic for Applications (VBA), known as Microsoft Visual Basic for Applications 7.0 (VBA 7), is being released to work with both 32-bit and 64-bit apps.
  Access Tools, Utilities and more… Gina’s Coffess Shop is a place where one can go to get a list of mostly free tools to use with Access.
  Developer Extensions Microsoft’s Access 2007 Developer Extensions
  Locations of Access 2003 Commands Where did the commands go in the new Microsoft Office Fluent user interface.
  Locations of Access 2003 Commands Where did the commands go in the new Microsoft Office Fluent user interface.
  Microsoft Access Services 2010 Hosting Access 2010 Tutorials and free 30 day SharePoint 2010 hosting.
  Microsoft Access Version History FMS has worked with Microsoft Access since it debuted in 1992. There have been many Access versions since then with multiple service packs, hot fixes and updates.
  Microsoft Access Version Releases FMS has worked with Microsoft Access since it debuted in 1992. There have been many Access versions since then with multiple service packs, hot fixes and updates.
  Microsoft Office Code Compatibility Inspector Tool to inspect VBA code that you created in 32-bit MS Office and helps you to make any Windows Application Programming Interface (API) calls in your code compatible with the 64-bit edition of MS Office 2010.
  MSDN Transitioning Your Existing Access Applications to Access 2007.
  Ribbon Customizer This tool will help you to customize your Database with Ribbons without writing a single line of XML code, this application will write all the code that is needed for you. The best part of this app is that it is FREE.
  Security Considerations and Guidance Find out how you can use Access 2007 to protect the information in your databases. Learn about encrypting files, administering passwords, converting databases to the new ACCDB and ACCDE formats, and using other security options such as SQL Server.
  Web Enabled Access Various methods that we can make data web enabled…Pros and Cons.


Add-ins and libraries for MS Access: import and export to Word and Excel, filtering, document management, data analysis and others.
  Allen Browne, VBA Function List Index list of the VBA code (Functions and Subs), found on site
  Allen Browne’s Tips Lots of tips–10 years of Usenet prowling–Beginner to Advanced
  Database Solutions for Microsoft Access Database design and implementation tutorials, articles, tips, tricks, code samples, Microsoft Access Help and FAQ’s and Microsoft Access database samples and examples available to download. Another source of well written VBA code samples
  Fabalou Web Lots of solutions for Microsoft Office Products (specializing in Access) and have lots of easy to understand examples for beginners and experts alike.
  Gaining Access Code samples by Patrick Wood Access MVP
  GPC Data Home of Smart Tools PAUG member George Hepworth MVP site.
  Granite Consulting Tony’s Microsoft Access tips, hints and links including Email FAQ and Access based accounting systems. One of the oldest Microsoft Access websites.
  Helen Feddema Code samples and newsletter
  Hook’D on Access Duane Hookom MS Access MVP 2001 to Present website. Many tips and samples.
  Importing from EXCEL Files and Workbooks Many different code samples for importing Excel files into Access.
  Lebans Holdings Ltd. Lebans efforts lie in enhancing Form, Control and Report Objects.
  MVP Web Sites Directory of all of the folks who are now, or have been in the past, designated as Microsoft MVP’s.
  Portland Visual Basic User Group Lots of links
  Roger`s Access Library Great source for demo samples of how to.
  SQL Formatter / SQLinForm This will let you paste in a SQL string and it will format it to your specifications (which you can set up).
  The Access Web Valuable resources from Access Guru Dev Ashish.
  Treeview control Treeview “control”, that only uses the native Office forms controls, no ActiveX. There are 200+ articles, newsletters and tips to read and search. Hosted by Access developer Garry Robinson.
  Visual Basic Resource A comprehensive set of tutorials, links, downloadable samples plus a chat room and message board for developers at all levels of experience.
  Zip file or files with the default Windows zip If you ever need to zip on unzip files using VBA give a look here.


Access Support Team Blog

Sharing frequent topics/issues encountered by the Access support team.
  Microsoft Access fan page on Facebook
  MS Knowledge Base How to query the Microsoft Knowledge Base by using keywords and query words
  MS Office Product updates, free trials, and third-party downloads
  MSMVPS.COM The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
  SQL Server Migration for Access Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
  Templates / Access databases List of all Microsoft Access Template, current versions and past.


Access to MSSQL

Try free demo version, it allows you to convert five records for each database table. (Do the rest with a append query.)
  Access to MySQL This utility will help you move the content of an Access database into a MySQL database. You can move the data and table definitions directly or you can create dump files for later use.
  Easy web page capture Save full or partial web page to file (jpeg, png or bmp) or to the clipboard.
  Excel Easy Tutorial (Introduction, Basics, Functions, Data Analysis and VBA) on how to use Excel. Want to learn much more about Excel? You can find related examples and features. They keep it easy!
  FMS Developer Help Center Resources to help you better understand and use Microsoft Access; Strategically, Best Practices, Table Form and Report Design, VBA and much more.
  FMS Inc Leading provider of developer tools and applications for the Microsoft Access.
  Juan Soto’s Access Tips and Tricks Blog Access Help and Tips by
  Leigh Purvis’s One of the top Access minds on the planet, has many example of different functionalities for Access MDBs
  Microsoft SQL Server Express Edition Download SQL Server Express is a free edition of SQL Server ideal for developing and powering desktop, web and small server applications.
  MZ Tools (free) MZ-Tools allows you to write code, find code, design your forms, document your applications, and review their quality much faster than you do it today. It saves you valuable time each and every time you use it.
  Smart Indenter (free) The Smart Indenter is a utility to tidy up VBA code by rebuilding the indentation of each line.
  SSW Upsizing PRO! As an Upsizing Tool, SSW Upsizing PRO! checks your database the way the `Microsoft Upsizing Wizard` should have done. After you use the generated reports, and made the recommended changes, you can upsize to SQL Server without any worries.
  V-Tools (free) Tools like – Total Search, Personal Object Library, Internal Pictures, Work on Queries, Import/export Specifications, System Colors, Form Templates, Container Objects Explorer



Award-winning learning solutions for developers, IT pros and computer users.


Blue Claw Access Programming Help

Access tutorials may give you the jump start you need. Programming examples from nearly all aspects of Access database development.
  BTAB Development – Free Samples / Quick Tutorials A great resource for quick visuals on how to do several things in Access and also several samples geared towards beginners. Bob Larson
  Computer Training Schools Featured Microsoft Access Schools in Oregon
  DataPig Technologies Access Tutorials, Freeware and Video Downloads by Mike Alexander MVP.
  FreeSkills Unlimited Access Training
  FunctionX Tutorials (free) Several great tutorials on Microsoft Access 2003/2007 as well as other technologies. All training on their site is free.
  PCC Class Search Portland Community College


Chicago Access Users Group

CAUG is an independent group of software developers and users of Microsoft Access and related products. Our mission is to meet and share information, techniques, and ideas, the fourth Thursday of each month.
  Denver Area Access Users Group The Denver Area Access Users Group helps Access users (from novice to professional) get the most out of Access through sharing current methods and techniques.
  Oregon Computer Consultants Association The OCCA seeks to provide a structure and forum for independent computer consultants working to share their knowledge, skills, and resources; and to promote the highest standards of professional and ethical conduct.
  Oregon SQL The Oregon SQL user group provides opportunities for SQL Server developers, .NET developers, and SQL Server administrators to meet and discuss SQL Server technologies that have a focus on the needs of the development community.
  Seattle Access Group/PNADG Our goal is to provide a comfortable environment where beginning to intermediate level Access developers and users can ask questions, find solutions to their problems and learn new tips and skills.