Clint Covington: Software design, Microsoft Office Access

Clint,

I don't find a shortcut menus editor in Access 2007...

How I can create shortcuts menu for Access 12 forms?

 Bob

Hi Clint

Bookmarked!

Maybe you can ask Janet to also let add following link there:

http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

This is the download of the ACE (Access Database Engine) to be used to access ACCDB (and Jet) files outside of Access.

Henry, MVP Access

Looking for Access 2007 information, I ran accross this Blog and thought I would add a comment / question...

I love to use cutting edge stuff but there is always a little pain...

I'm developing a .NET 2005, Windows forms application for disconnected data entry. The application will use a Web Service to send/receive data updates when connected. I decided to use MS-Access 2007 for the local client data store.

I've installed the Access 12 components ("AccessDatabaseEngine.exe") and use OLE DB to connect to the database in the App - works great!

The App is at final beta stage and I'm ready to use ClickOnce to test the deployment side of things...

One item that I though may be useful is a prerequisite entry for the Access12 components. After looking around, I get the impression that this may not be available yet??

I also had attempted to add a function in the application that would programmatically compact the database. I had to leave this option command button disabled for future implementation because I haven't found any "How to's" regarding Access 12.

Can anyone help me out with answers to these issues? Or, should I use good old Access 2003 for now?

Thanks a bunch for any help,

Bob Maupin

I've discovered an important performance problem of Access 2007 interface (on Windows XP, I have not still installed win Vista)

If an application is running with the new "tabbed" view interface, performances are similar to A 'XP/2003 releases: ok

Vice-versa if the same application is running in traditional view, Forms (single forms, not tabular) with a lot of bound controls are very, very slow ... unusable on many PC(s).

Clint, this isn't a bug but an ELEPHANT    ;-(

Microsoft developers haven't debugged this product before the sale?

Bye

I realize that this may not be the best place for this, but maybe not…

For those looking for a way to Compact/Repair an Access 2007 database from a .NET application (2.0) I have successfully used the following procedure:

- Install the “AccessDatabaseEngine.exe” components.

- Add a reference (COM) to the project (mine was a Win-Forms application) for the following:

"Microsoft Office 12.0 Access Database Engine Object Library"

- In Code:

 - Disconnect from the database

 - Create a new instance of “Microsoft.Office.Interop.Access.Dao.DBEngine”

 - Call the instance method “.CompactDatabase” and provide the SrcName and DstName as strings.

I noticed that the following properties are available but have not used them yet:

.DefaultUser

.DefaultPassword

After compacting the .accdb file I used some re-naming to create a backup copy (SrcName) and rename the new file to the original filename.

I've successfully tested this using a ClickOnce deployment on a client that does not have Office 2007 installed.

Bob Maupin