SharePoint Apps Offline and Intro to SharePoint Designer

re: SharePoint Apps Offline and Intro to SharePoint Designer

ric — Thu, 01 Feb 2007 03:25:51 GMT

I see in your strategy document you say The primary application programming interface (API) for working with the Microsoft Jet database engine from code is Data Access Object (DAO). In Office Access 2007, new objects, properties, and methods will be added to DAO to support the new features in the Access database engine. For example, multi-valued fields created using the new Lookup Wizard will be accessible from code as DAO recordsets. I thought DAO was deprecated and ADO was the preferred technology to use. Please explain when you are saying each should be used. Thanks

re: SharePoint Apps Offline and Intro to SharePoint Designer

Ric — Thu, 01 Feb 2007 02:34:53 GMT

Depressing reading for anyone with real users, relational data and an interest in moving towards browser/web deployment without the hassle of deploying or hosting SQL server. Plugging these apps into SharePoint would be wonderful if it was going to work If you have a relational database structure and want to share it, with synchonisation/replication, and web access, and use Access as a development tool, what are MS suggesting as the approach? It would be great if you could deploy an Access relational database structure to Sharepoint with confidence, build Sharepoint forms for simple tasks, and have reliable replication back to the core app sitting in say a small office. Similarly, th eother apps liek Groove look interesting but don't seem likely to help database developers. No-one has talked of Access 2007 front ending SQLExpress - is it a viable option? Where is the MS road map for the next few years? How do Jet, Access, the MSSQL variants and Sharepoint fit together?

re: SharePoint Apps Offline and Intro to SharePoint Designer

Alan Cossey — Fri, 22 Dec 2006 11:15:08 GMT

This is a former cynic here. When I first saw what was going on with Access 2007, I was not particularly impressed. However, the more I look at it and see things like much better security (even if you have to jump through hoops to use it effectively) and Sharepoint integration, the more I am impressed. I have just started playing with Office Live and am mega impressed with how it works with Access and Outlook (haven't tried it with Excel yet). I was in no hurry to get involved with Sharepoint, but it has loads to offer.

re: SharePoint Apps Offline and Intro to SharePoint Designer

John Harris — Mon, 04 Dec 2006 05:01:39 GMT

Erik / Clint Is this blog still active? I was hoping for some more posts from you guys...

re: SharePoint Apps Offline and Intro to SharePoint Designer

HelpPlease — Fri, 01 Dec 2006 16:38:41 GMT

I have an appplication that reads information from Access Database, it uses ADO (msado15.dll) to open a database using Connection15::Open( ). I am unable to open Access 2007 database using this method. I get the following error: "Microsoft JET Database Engine, Unrecognized database format". Is there something I am doing wrong or I should be aware of? Does msado15.dll support Access 2007 databases? Thank you in advance.

re: SharePoint Apps Offline and Intro to SharePoint Designer

AL — Mon, 20 Nov 2006 04:54:10 GMT

Geez, if they left the ribbon out of Access 2007, you would complain about that too. All we really want is to keep the old stuff available, as a developer choice, and to preserve our investment in "legacy" (i.e. this year's) code. Running at 1280 x 1024, the ribbon looks just fine :-)

re: SharePoint Apps Offline and Intro to SharePoint Designer

StepUP — Sat, 18 Nov 2006 18:09:57 GMT

And besides Infopath, Visio and Outlook, also mysteriously lacking the Ribbon: OneNote

Project

Publisher

Sharepoint Designer So the wonderful Ribbon is somehow not included in all of these apps (7 out of 11 Office 2007) , but is forced upon us in Access. Unbelievable!

re: SharePoint Apps Offline and Intro to SharePoint Designer

yeah — Fri, 17 Nov 2006 07:26:39 GMT

...and Infopath 2007 does not have the Ribbon

Visio 2007 does not have the Ribbon

Outlook 2007 kinda has the Ribbon but, to be honest, I kinda like the ribbon...well just a little. It really irritates me that they did not bother to include it with Infopath or Visio. To me that says "RUSH JOB".

re: SharePoint Apps Offline and Intro to SharePoint Designer

ItsMe — Fri, 17 Nov 2006 04:17:26 GMT

But the website says it (OA2007) has: "a familiar and consistent user interface that works with and looks like other Microsoft Office programs." Hmmm....

re: SharePoint Apps Offline and Intro to SharePoint Designer

mark — Thu, 16 Nov 2006 14:21:20 GMT

Has anyone taken a look at Microsoft OFFICE Accouting 2007 at www.OAisbetter.com? This is not Microsoft Money, not Microsoft Great Plains, not Microsoft Navision. This is a product branded as Microsoft Office complete with the familiar muti-color frame logo. Microsoft has spared this spanking new application from the "ribbon/no menus for you" design foisted upon Access 2007 developers. How can they justify this inconsistency? How can they proclaim that users will find the ribbon experience superior to conventional menu structures and then not implement the ribbon in this NEW application, written to complete against Quickbooks and Peachtree? If their own developers reject the ribbon nonsense for application development under the "Office" moniker, why do they insist on sticking it to Access 2007?