New Access 2007 Articles on Office Online

Published 13 August 07 06:33 PM

Thanks to Jeff Conrad on the Access test team for this: 

Office Online now has published four articles with material pulled from the Microsoft Office Access 2007 Inside Out book. This enormous book, published by Microsoft Press, is co-authored by Access MVP John L. Viescas and recent Microsoft hire Jeff Conrad. You can find these new articles at the following links:

Exploring a desktop Access 2007 database:
http://office.microsoft.com/en-us/access/HA102326851033.aspx

Create an Access 2007 database using templates:
http://office.microsoft.com/en-us/access/HA102326861033.aspx

Build forms in Access 2007 using design tools:
http://office.microsoft.com/en-us/access/HA102326841033.aspx

Automate applications with macros in Access 2007:
http://office.microsoft.com/en-us/access/HA102326831033.aspx

by Zac Woodall
Filed under: , , , , , , , ,

Comments

# Oli-S said on August 13, 2007 8:19 PM:

Thanks John and Jeff for making this possible!

# Daniel said on August 14, 2007 11:46 AM:

When will be possible to compile .mde or .accde to .exe?

# Zac Woodall said on August 14, 2007 2:43 PM:

Sorry Daniel, that isn't something we're looking at.  If you want to distribute a solution to users who don't have Access, your best bet is the Access runtime.

http://blogs.msdn.com/access/archive/2007/07/23/access-runtime-re-released.aspx

Also, for future reference, this sort of question is best asked in one of the Access community venues:

http://blogs.msdn.com/access/archive/2007/07/31/access-communities.aspx

# Doug said on August 15, 2007 1:40 PM:

Hi Zack,

This is completely off-topic, but I am not sure where else to turn as there is little here about Access and SharePoint and the posts that do exist are closed and quite old....

Anyway, I am stumped.

If I export Northwind 2007 to WSS 3.0, the tables, like Customer, that contain 'Contact' type information get exported to an WSS 'Contact' content type. Very cool! Now you can view them in Outlook as a contact list.

However, if I craft a table from hand with the exact same name, and the exact same fields, and export it, it is exported as a 'Custom' content type and I get no Outlook love.

What magic is done in Northwind to make this happen? I really want to be able to do the same thing.

P.S. Access makes a great front end for reporting on data from SharePoint. Please, more content about Access and WSS!!!

# Zac Woodall said on August 16, 2007 4:12 PM:

Great question Doug!  Check this out:

http://blogs.msdn.com/access/archive/2007/08/16/set-sharepoint-list-template-for-access-table.aspx

New Comments to this post are disabled

About Zac Woodall

Zac is a Program Manager at Microsoft on the team designing Access’s next generation platform infrastructure. He advocates easy to use designs, organizes community efforts, and is the author of The Rational Guide to Microsoft® Office Access 2007 Templates. Zac has been working at Microsoft Corporation since 1999. Before that time, he attended the University of Idaho, from which he holds a B.S. in Computer Science.
Page view tracker