Access Developer Extensions
By Richard Rost 16 years ago
Jeff, good question.
One of the nice things I do like about the new Access 2007 is that the Developer Extensions are FREE. This is a program that you can download and compile your Access database up into a "program" that you can distribute to others free of charge (no licensing, no royalties) and they don't need to have Access. The end users cannot MODIFY your program/database - but then again, you probably don't want them to anyhow.
You can download the free Access 2007 Developer Extensions from Microsoft's Web site.
You can also download just a Runtime version of Access which you can give out to people with your database. You give them the database files and the Runtime. They install the Runtime themselves - good to go. Same thing, just no packaging wizard.
In previous versions of Access, you had to BUY the developer extensions. For Access 2003 they were part of the Visual Studio Tools for the Microsoft Office System. There is a free trial version available on the Microsoft Web site so you can evaluate it.
In earlier versions (XP, 2000) you had to buy the Microsoft Access Developer Edition, and in Office 95 and 97, Microsoft had a special Developer Toolkit you had to buy. Same features.
Now for Excel, I know that Microsoft has a Spreadsheet Viewer application that they allow you to download and distribute for free. Here's the Excel Viewer 2003.
Apparently as of right now, there isn't an Excel 2007 viewer available. I did find this interesting article on how to view Word 2007 and Excel 2007 documents using their 2003 viewers. There's also this blog item on the MSDN page.
Hope this answers your question.
Of course, Microsoft wants people to be able to distribute their Access applications. There's a lot of competition from other database programs, and to force Access developers to have to pay hundreds of dollars to distibute their databases doesn't grow their platform any. As far as Word and Excel goes, however, Microsoft wants people to have to buy these programs to modify their documents.
It is on my list to add a tutorial in how to use the Developer Extensions. Seeing as how the 2007 ones are free now, however, I might just wait to show you those! I haven't purchased the 2003 edition (still use XP myself). 2003 was a minor upgrade for Access anyhow.
Subscribe to Access Developer Extensions
Get notifications when this page is updated