Tag Archives: Access

Access 2007 Deployment File Formats

Notes from the Access 2007 help file:

There are four standard file formats for Access 2007 deployed files:

  1. .accdb standard file format for Access 2007
  2. .accde compiled binary file. This strips the VBA source code from the file
  3. .accdc combined version of Access application file, and a digital signature associated with the file
  4. .accdr format for running an application in runtime mode.

More on signing and creating the .accdc file:

I love this:

Note: Although this feature is also known as “packaging,” it does not accomplish the same tasks as the Package Solution Wizard of the Access 2007 Developer Extensions. The feature described in this section packages an Access 2007 file and applies a digital signature to the package that helps indicate to users that the file is trustworthy.

So if I’ve got this right, I can use the Packaging Wizard (discussion from yesterday) to package and deploy an .accdc file which is a signed version of my access workstation file. Whew!

Access 2007 Packaging an Application

Now that the Access 2007 runtime is available, it is time to start working with Access 2007 again for client deployments. The first order of business was to start up the Developer Extensions.

The Microsoft Access 2007 Developer Extensions are available as a free download from Microsoft.

By default these are installed in C:\Program Files\Microsoft Office\. I changed this to add a folder Acc2007DE so I could find them, but even then couldn’t figure out what was supposed to be happening.

Turns out that the Developer Extensions are are a COM add-in, consisting of:

Package Solution Wizard – this is similar to the older package wizard with Access 2003.

Save as Template – Allows you to save an existing database installaton as a template. Note that this is not the same as saving a database design as a template!

These appear under the round Microsoft Button in the upper left-hand corner of the Access Window.

(my screen shot programs don’t appear to be able to deal with the dropped-down menu, so you’ll need to use your imagination. )

In the following screens shots, click on the image to see a larger version.

If the Developer option does not appear under the button, do the following:
1. Click the button
2. Choose Access Options
3. Choose Add-ins
4. At the bottom of the screen choose Manage COM add-ins, then GO
5. You should get a screen showing the currently available add-ins. Like this:

Ok, so let’s try the Package Solution wizard. Here is the first screen.

I changed the destination folder to F:\Access Install Packages.

The Package Solution Wizard asks for several parameters. Since I usually install an Access application off of the C:\ root, I chose System Drive (All Users) for the location plus the folder name in the Root install folder, and thent the actual folder name uner the Install Folder. The actual install location will show up in the Example install location field.

You can use the third option under t he section regarding the Pre-installation requirements if you want to install the Access runtime on a computer which does not contain Access 2007. To include this in your setup, you’ll need to point to to a locall copy of Accessruntime.exe which you can download from the Microsoft web site.

Note under the Example Install Location, that the installed version of the program will have an .ACCDR extension, as opposed to the normal Access 2007 extension of .ACCDB.

The Acccess 2007 help files include a subset of subjects, called “Developer Reference”

Access Runtime is Back!

The Access 2007 runtime is available again. I had some problems installing this over the previous version. If the installation seems to hang up try deleting the existing version and then reinstall.

Access 2007 file formats are different, and new, and not entirely backward compatible.
Here is a help file which explains how they work.

Microsoft Access 2007 Runtime is now available

The Microsoft Access 2007 runtime is now available at this link. Hooray!

You also need to download and install the Developer Extensions to allow you to build an Access 2007 solution that includes the Access runtime.

After installing these, I was a little nonplussed, as I couldn’t seem to find any of files to start the Packaging Wizard…which is the wizard to step you through the creation of a set of installation files for your Access application. This is now tucked under the “Developer” tab within Access 2007. There is no separate menu item off the Windows start menu.

Tangled up in Macros – Errors when opening Access Files

Eliminate the Macro Security messages when opening Access projects.

Here is a fix for a perennial problem, which appears to work.

I’ll spare you the rant.

You need to run this on every workstation which uses your application, so in a networked situation, this needs to be part of the installation routine on each workstation.

Access 2007 Runtime Delayed & Linux Patent Assault

Microsoft Matters:

The Access 2007 runtime which was scheduled to be available today is delayed by a couple of weeks.

In other news:

Microsoft also seems to be trying to pick up where the SCO lawsuit left off, by threatening companies using Linux for patent infringement. Same story as before…they won’t say what is being infringed, won’t point to any code in particular. They mention OpenOffice (which isn’t Linux, of course, merely open source). Lots more about this over on Slashdot.

What a crock!

It is behavior like this which makes a customer think about where they are sending their money.

It’s like General Motors blaming their customers for not buying enough GM cars.

It’s like health insurance companies blaming their customers for whinging about the cost of premiums which rise at 2 or 3 times the annual rate of inflation.

Books for Microsoft Access 2007 and earlier

I was going to do a list of my favorite Access books…but Erik Rucker already posted one. His blog, “What’s new in Access 2007” has been going since late 2005. Erik is the program manager for Access 12.0 (aka 2007) at Microsoft. I expect when the runtime is announced it will appear here first. (To paraphrase the late-nite tele-marketing shill..”Programmers Are Standing By!)

Erik’s annotation consists only of the publisher’s blurb, not any kind of comments or review. Several of the books have publishing dates for April and later.

My own favorite books, which cover Access 2003 include:

Grover Park George On Access This book is especially good for those with limited database experience. GPG is a regular on the Utter Access forum, and even answers eMail questions.

Fixing Access Annoyances I wrote about this book previously, it is full of workarounds to pesky problems in Access 2003 and earlier.

Access Hacks

Microsoft Access Data Analysis

Finally, the other day I picked up VBA for Dummies, hoping for a little more detail about Visual Basic for Applications, the version of BASIC which is used when programming the Microsoft Office programs. The 5th edition actually deals with Office 2007, (i.e. The Ribbon), and I found several good tips.

VBA works for Outlook, Word and Excel, too, of course, and is especially helpful when you want to glue the applications together, by sending eMail from Access for example or using Word to create reports from Access.

Simulate Access 2007 runtime

Clint Covington has a hint to allow us to get a preview of what a project will look like when running under the Access 2007 runtime:

I know, the runtime hasn’t shipped yet. If you are looking for a simple way to share a database with co-workers and you don’t want them messing around with things… Try renaming the file to ACCDR. This is the equivalent of running the database with the /runtime switch. Basically the ribbon and nav pane get turned off.

I found a comment on a German blog quoting somebody who was quoting somebody that the runtime would ship “sometime in the March timeframe”. Let’s hope so.