Ms Access 2000 Runtime

| Posted on by

I thought I’d take a second to explain what Access Runtime is, and is not.

  1. Ms Access 2000 Runtime Pro
  2. Ms Access 2000 Runtime Update
  3. Access 2000 Runtime Path Msaccess.exe
  4. Ms Access 2000 Free Download
  5. Ms Access 2000 Runtime Edition

What is Access Runtime?

  1. Ms Access 2000 Runtime Download Free. 0 Comments Store your data in SQL Server and Microsoft Azure SQL to enhance reliability. Microsoft Access 2016 is the.
  2. Utilities / Password Recovery. Use Microsoft Access Password Recovery program to recover ms access password of Microsoft Access 95, 97, 2000, 2002, XP, 2003. Microsoft Access Password Recovery is an advanced featured program that ensures recovery of multilingual password, recovery.
  3. Microsoft Access Runtime Distribution and Free Downloads. Microsoft offers runtime versions of Microsoft Access so you can create database applications in MS Access and distribute them to non-Access owners. The runtime version allows your users to use your databases without purchasing their own license of Access/Office.

Documented on page 32 of the Access 2000 Developer`s Handbook Volume 2: Enterprise Edition still affects the runtime. Apparently page locking is invoked when using the Access run-time record than record-level locking. This also affects Access 2000 but if you patch Access the bug is fixed. I really don't know about the runtime though.

In the simplest terms, Access Runtime is a stripped down version of Access in which the developer/design tools have been removed/disabled.

What is Access Runtime Used For?

Access

Access runtime is installed for users that do not already have a Full licensed version of Access. So long as your user does not need to create and/or edit database objects such as: Forms, Report, VBA code, … then the FREE Access Runtime will be perfect for them and allow them to run and use any existing database.

So Runtime allows you to distribute your database to user that do not already have Microsoft Access at absolutely no cost!

Some developers will actually install the runtime version, regardless of whether or not their users already have the full version of Access installed, because it adds an additional layer of security to their databases and restricts what their users can change.
Access

What Access Runtime Is Not?

As mentioned above, Access Runtime is not a development tool. Developers still require the Full version of Microsoft Access to be able to create/edit a database.

Access

An analogy might be imagining Runtime as a car. You can drive around town all you want and use it, but if you want soup up your car, you still need to visit a mechanic (Access Full version).

Ms Access 2000 Runtime Pro

Where Can You Get Access Runtime?

Below are links to Microsoft’s Runtime downloads.

MS Access 2007 Runtime
MS Access 2010 Runtime
Ms Access 2013 Runtime
Ms Access 2016 Runtime

Access 2000 runtime path msaccess.exe

Things To Be Aware of With Access Runtime!

Since, all development tools have been removed/disabled,

  1. You cannot debug any VBA errors, thus it is critical to add error handling to all your VBA procedures otherwise when an error occurs the database will crash
  2. You do not have access to any of the option menus, so you need to find an alternate method to
    1. Set general database properties (startup form, title, …)
    2. Create Trusted Locations to enable the VBA code within your database (this can be done with vbscripts)
  3. Tools like the Linked Table Manager are not accessible, so you need to implement an alternative
  4. There is currently no Runtime version for Click-To-Run editions of Office 365. It is only available/compatible with MSI versions of Office. That said, Microsoft now include Access with all Office365 editions, so all Office365 user should already have access to Access, no need for the Runtime version for them.

From Microsoft, below is a list of the feature which are removed from Access Runtime.

The following features are not included as part of the Access 2007 Runtime without additional customization:

  • Navigation Pane
  • Title bar text/icon (can be specified by the database instead of by Access)
  • Default Office Fluent Ribbon
  • Quick Access Toolbar
  • Shortcut menus
  • Access Help
  • Designers (including Filter by Form)
  • Visual Basic Editor

Ms Access 2000 Runtime Update

Taken from: Basics for Building Access 2007 Runtime-Based Solutions

Simulating Runtime

As a developer running the Full version of Access we sometimes need to test how our application will behave in the runtime environment. Now in an ideal world you would build a Virtual Machine (VM) that has the runtime version installed. That said, Access does have a command line switch that can be employed with the full version to simulate the runtime environment. So you can use the /runtime command line switch as part of your call to open a database and see exactly how you database will look and behave in the runtime version of Access.

So you would use a command similar to the following in a command prompt, bat file, vbscript, …

Access 2000 Runtime Path Msaccess.exe

“C:FullPathTomsaccess.exe” “C:FullPathToDatabase.mdb” /runtime

Ms Access 2000 Free Download

Access

This is also where my Context Menu can truly help developer. To find out more, take a look at my post entitled Windows Explorer MS Access Database Right-Click Context Menu.

Ms Access 2000 Runtime Edition

More Resources on the Subject