Access How To's (2003, 2010, 2013, 2016, 2019, Office365 / Office 365 and Microsoft Office ) Updates, Version Info, How To's, HotFixes, Etc

Getting More Information About Access (Bugs & Bug Fixes)

Access Forever bugs, tools, events

How to Compact / Repair / Decompile

How to Decompile

• Open Start > Run > then type: msaccess.exe "...full path name\database name.mdb" /decompile
• Then press the Open button.

• NOTE: It is BEST to run the /decompile option FIRST (This will usually help the file compact down much smaller, and may help us repair corruption more successfully)
• Open Start > Run > then type: msaccess.exe "...full path name\database name.mdb" /repair
• Then press the Open button.

Office 365

How to revert back (roll back) to an earlier version (build) of Office 365 (including Access)

https://www.cnet.com/how-to/how-to-revert-to-the-previous-version-of-office-365/

Microsoft Office BUILD History

• Access 2010: https://docs.microsoft.com/en-us/officeupdates/update-history-office-2010-click-to-run
• Access 2013: https://docs.microsoft.com/en-us/officeupdates/update-history-office-2013
• Access 2016 / 2019: https://docs.microsoft.com/en-us/officeupdates/update-history-office-2019
• Access / Office365: https://docs.microsoft.com/en-us/officeupdates/update-history-office365-proplus-by-date

Access 2019 / Office Professional Plus 2019

How to Buy the proper version of Access 2013 for use with OneSource

For various reasons, OneSource runs best on a Windows 2008 or Windows 2012 Server using Remote Desktop (RDP).  In order to 'install' Microsoft Access 2013 (or Microsoft Office Professional which contains Access 2013) you cannot just go buy a copy of Access or Office at an office supply store--because it won't install.  In order for the product to 'install' on a server running Remote Desktop you must buy Microsoft Access 2013 (Open Business) or Microsoft Office Professional Plus 2013 (Open Business).  Also, in order to open an 'Open Business' account with Microsoft you must buy a minimum of 5 licenses (of any type).  That being the case you have 2 choices when buying 5 licenses:

1. Buy 1 license* of MS Access 2013 (open business) or 1 license of MS Office Professional Plus 2013 (Open Business) and then buy 4 additional licenses, such as Remote Desktop 'Client Access Licenses' (CALs) or Windows Server CALs (if you are buying the licenses for a new server) or even some other type of Open Business product as a 'filler' (to help you meet the 5 license minimum) such as 'Forefront Unified Access Gateway, User CAL - Open Business, or
2. Buy 5 or more licenses* of MS Access 2013 (open business) or 5 or more licenses of MS Office Professional Plus 2013 (Open Business).
   
   * OneSource can be operated using the free 'Runtime' version of MS Access by adding the /runtime switch on the OneSource 'shortcut' on each users desktop.  However, the runtime version prevents the use MS Access to manage tables, queries, etc--so you will need at least 1 copy of MS Access for this purpose.  On the other hand, if you plan to allow all your users to use the various applications that come with MS Office Professional Plus (such as MS Outlook or MS Word) then to properly license the use of those products you will need a license for each user.}
   
   If you purchase a Server from OneSource Software Solutions we will include the necessary Windows Server CALs, Windows Remote Desktop CALs, and the MS Office Professional Plus 2013 CAL with the server.  You can also purchase the Open Business versions of MS Office Professional Plus or MS Access from a number of resellers on the web.  Here is one reseller that we like:
   
   www.softwaremedia.com
   Katie Petty
   800-474-1045 ext 696 (toll free)
   801-433-9696 (direct line)
   kpetty@softwaremedia.com
   
   Here are a few sku's that may be of interest to you:
   -- Office 2013 Professional Plus - License - Open Business, item #: 79P-04749 ($454.99 as of this writing)  
   -- Windows Remote Desktop Service 2012 - User CAL - Open Business, item #: 6VC-02073 ($119.25 as of this writing).
   -- Access 2013 - License - Open Business, item #: 077-06674 ($167.00 as of this writing)
   -- (Low cost Open License 'Filler' license) Forefront Unified Access Gateway - User CAL - Open Business, item #: 37D-00110 ($11.99 as of this writing)  

How to open and trust OneSource in Access 2013

• On Windows 2012 Server
• Start Menu > (click Down arrow - to see Apps)
• Click on MS Access 2013
• On left side, click Open Other Files
• On left side, click Options
• Click on Trust Center > Trust Center Settings > Trusted Locations > Add New Location > Browse...
• Browse to location of OneSource folder (usually C:\OneSource)
• Click on checkbox called Subfolder on this location are also trusted
• Additional settings to change:
• Click ActiveX Settings (on the left) > Enable all Controls...
• Click Macro Settings (on the left) > Enable all macros...

How to configure the Trust Center for ALL users in 1 place

• https://www.microsoft.com/en-us/download/details.aspx?id=49030
• https://docs.microsoft.com/en-us/previous-versions/office/office-2013-resource-kit/ff400327(v=office.15)

How to check for the latest version

• How to determine the latest: http://www.fmsinc.com/microsoftaccess/history/versions.htm

See a comparison of multiple MS Access versions features - side by side

http://www.opengatesw.net/ms-access-tutorials/Microsoft-Access-Version-Comparison.htm

How to 'Repair' Office using the online tool.

• Close Microsoft Office (including Outlook and Access)
• Browse for Microsoft Office Online Repair Tool

How to Learn How to Really Use (and Develop) Microsoft Access ( Access Training )

• https://www.udemy.com/topic/microsoft-access/

Access 2010

1--How to get Microsoft Windows and Microsoft Office Updates

• Windows 7 / Windows 2008 Server R2
• Start > All Programs > Windows Update
• Click on the 'Check for Updates' link on the left side.
• Follow the prompts.
• Windows Vista / Windows 2008
• Start > Control Panel
• Double click on Windows Update
• Follow the prompts
• Windows XP / Windows Server 2003 R2
• Start > All Programs > Windows Update
• After landing on the Windows Update (webpage) click on the Microsoft Update option on the Top/Center menu bar.
• Click on Start Now and follow prompts.

2--How to Determine the Version Number for Your Version of Microsoft Access:

• 2010: File > Help > (Version is on right hand side)
• How to see all installed apps/versions: Start > Search (or Run), type appwiz.cpl and press enter.
  

3--Microsoft Access 2010 - Current Version #

• MS Office Professional 2010, Microsoft Access 2010, Office 14
• THIS INFO LAST UPDATED: 7/21/2014
• 14.0.7195.5000 (32bit) with SP2 (last updated by SBC on 4-19-2019)
• How to determine the latest: http://support.microsoft.com/kb/2121559 and http://www.fmsinc.com/microsoftaccess/history/versions.htm

4--Microsoft Office Support & Update Links

• Version comparison Info: http://technet.microsoft.com/en-us/office/ee748587.aspx
• Microsoft Support Site for Office 2007/2010 http://support.microsoft.com/ph/13615
  

5--Access Command Line Switches and Arguments

http://support.microsoft.com/kb/209207

(For compact and repair, etc)

6--Access System Resources Exceeded Error hotfix

First refer to this KB from Microsoft. https://support.microsoft.com/en-us/kb/2760394

• Click the "Hotfix Download Available" button 
• if a download is available you will be guided through requesting and downloading the hotfix

After you install the hotfix package, follow these steps to enable the hotfix:

1. Click Start, click Run, type regedit in the Open box, and then click OK.
2. Locate and then click one of the following registry subkeys.
   • On 32-bit versions of Access on 32-bit versions of Windows or 64-bit versions of Access on 64-bit versions of Windows:
     HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access Connectivity Engine\Engines
   • On 32-bit versions of Access on 64-bit versions of Windows:
     HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Access Connectivity Engine\Engines
3. On the Edit menu, point to New, and then click DWORD (32-bit) Value.
4. Type WorkingSetSleep, and then press Enter.
5. In the Details pane, right-click WorkingSetSleep, and then click Modify.
6. In the Value data box, type 1, and then click OK.
7. Exit Registry Editor.

7- How to change the Menu bar in Access 2010 on OneSource to show just the Drop Down Menus without the Add-In tab.

• Open OneSource into OSShow Mode.
  
• In Access go to the Red File tab and click Options
• Then click on the Current Database option on left.
• Scroll down to the Navigation area and in the Menu Bar drop down list select OSMainMenu2
• Turn the copy of OneSource back into the OSHide Mode. (this is a must to show only the 1 menu bar without tabs.)
  

Access 2010 Configuration

To Show Tabs across the top of the screen for each open Screen

• Login to OSHOW
• Click File > Options > Current Database > 
• Under Document Window Options select: Tabbed Documents and also Display Document Tabs.

Access 2003

1.1 -- How to download and install the Microsoft Access 2003 SP3 HOTFIX (REQUIRED)

• Close all applications (including OneSource and all other applications related to MS Office)
• Before downloading and installing the HOTFIX be sure to make sure that your version of Office 2003 Pro or Access 2003 Pro is completely updated to SP3. (See Section 2.0 below for instructions on how to check and apply updates).
  
• Prep for and download the Hotfix:
• Create a folder on your Desktop called Temp. 
• Download, Save, and Extract the Hotfix from Microsoft using the following link: http://download.microsoft.com/download/6/4/0/640eb828-5556-4588-8e1a-66fe8e0e3ad9/office2003-kb945674-glb.exe  (or simply copy and paste this link into your browser Address line).
• After you click on the hyperlink above a File Download dialog box will appear.
• Click Run.  (If another security dialog box appears, click Run again).
• When the Hotfix dialog box appears, click Yes.
• When the 2nd Hotfix dialog box appears, click Browse, and then scroll down toward the bottom of the list and double click on the Temp folder (you created previously). 
• Then click OK.  Then OK again.
• Now browse to the Temp folder on your desktop (if necessary, minimize all other windows) and double click on the MSACCESS.msp file.  Follow the instructions in the installation wizard to complete the process.   
• Repeat this process on any PC using OneSource (or MS Office 2003).

1.2 -- How to remove Access 2003 Security Warnings

• After Microsoft Office 2003 ( Microsoft Access 2003 ) has been installed, for each separate Windows user account, when the user first opens OneSource they may receive a warning message that includes the following:
  
• Security Warning: Unsafe expressions are not blocked.  Do you want to block unsafe expressions? 
  
• To the message displayed about from popping up again you need to just click NO when prompted.
• You may also see this warning: 'Unsafe expressions are blocked.  You can configure your computer to allow Expressions to be evaluated.  Do you want to allow the evaluation of potentially unsafe expressions. '  
• You need to click: Yes
  
• Another Security Warning dialog box may appear after that, that includes this question:
  
• 'The file may not be safe if it contains code that was intended to harm your computer.  Do you want to open this file or cancel the operation?  (You need to click: Open)
• NOTE: To prevent this 2nd security warning from re-appearing each time the user opens that copy of OneSource, the macro security settings need to be changed to Low by doing the following:
• Login to OneSource.
• Click Tools > Admin Tools > MS Access Menu's > Tools > Macro > Security.
  
• Chance the setting to Low and then click OK.

2.0 -- How to get Microsoft Windows and Microsoft Office Updates

• Windows 7 / Windows 2008 Server R2
• Start > All Programs > Windows Update
• Click on the 'Check for Updates' link on the left side.
• Follow the prompts.
• Windows Vista / Windows 2008
• Start > Control Panel
• Double click on Windows Update
• Follow the prompts
• Windows XP / Windows Server 2003 R2
• Start > All Programs > Windows Update
• After landing on the Windows Update (webpage) click on the Microsoft Update option on the Top/Center menu bar.
• Click on Start Now and follow prompts.

2.1 -- How to Determine the Version Number for Your Version of Microsoft Access:

How determine the version of Access

• In 2003
• Help > About
• In 2007, 2010, 2013, 2016
•  File > Help

• In OSShow mode, click Ctrl+G
• In the Immediate Window type: ? Access.CurrentProject.FileFormat  (then press Enter)
• 10 = Access 2000
• 11 = Access 2003
• 12 = Access 2007
• 14 =  Access 2010
• 15 = Access 2013
• 16 = Access 2016 (I think...)

2.2 -- Microsoft Access - Current Version #'s

• MS Office Professional 2003, Microsoft Access 2003, Office 11
• THIS INFO LAST UPDATED: 4/14/2012
• 11.8166.8172 - with SP3
• 11.8204.8221 - after applying the CRUCIAL Access 2003 Hotfix (See instructions on how to do this in section 1.1 above) 
• 11.8321.8405
• Check Here For The Latest Updates http://support.microsoft.com/kb/821549
  

2.3 -- Microsoft Office Support & Update Links

• Version comparison Info: http://technet.microsoft.com/en-us/office/ee748587.aspx
• Command Line Switches: http://support.microsoft.com/kb/209207
• /Compact
• /Repair
• /Decompile