[AccessD] Open Access 2007 forms and reports fromWindowsSharePoint Services

Shamil Salakhetdinov shamil at users.mns.ru
Wed Oct 11 12:44:18 CDT 2006


Thank you for your answer, Martin!

<<<
The install is a real pain in the ass so be warned.
>>>
Thank you for the warning, Martin.
I then better wait for release. :)

<<<
New form property allows you to expose the form on WSS and the same with
reports. The user click the report for example and it opens in Access.
>>>
OK, and you can still use such forms/reports in an offline database?


BTW, I'm trying to find what are the new objects/properties in MS Access
object model - so far I did find these:

- Attachment
- ImportExportSpecification
- ImportExportSpecifications
- MacroError
- TempVar
- TempVars

Is there somewhere a full list published?


And MS Office 2007 object model has a lot of new objects:

- Arcs
- Axes
- Buttons
- ChartFillFormat
- ChartFont
- ChartGroups
- CustomTaskPane
- CustomXMLNode
- CustomXMLNodes
- CustomXMLPart
- CustomXMLParts
- CustomXMLPrefixMapping
- CustomXMLPrefixMappings
- CustomXMLSchema
- CustomXMLSchemaCollection
... etc ...

These all to work with XML, Ribbon, SharePoint, Worklflow... as far as I may
guess...

The new Sync object is obviously (?) to synchronize client apps's objects
with SS services object vault...

Yes, quite some new features there to learn about!

I must say I still to adapt to the Ribbon - is there a possibility to switch
it off completely and use good old commandbars? :)

--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid
Sent: Wednesday, October 11, 2006 8:40 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Open Access 2007 forms and reports
fromWindowsSharePoint Services

It creates the database or you can link to an existing database.
There are a number of ways this works. The database can be exported to WSS
and you are left with a copy of the entire DB on Sharepoint and links in
your access application. Its really cool with new caching features. You can
cache data in the database for of line working and then synch it back to
SharePoint. It can lead to database growth but ists a nice feature.
 
There will be a some point soon the ability to take a SharePOint site and
create a full databse from the lists.
 
 
Some of the features are really nice. New form property allows you to expose
the fom on WSS and the same with reports. The suer click the report for
example and it opens in Access. 
 
Access runs as an independ linked application. The forms etc that are in the
created databse depend on settings you make yourself when exporting.
 
Its worth actually installing MOSS 2007 and Office 2007 on a Virtual machine
to see how this works together. The install is a real pain in the ass so be
warned. You need to install MOSS Beta 2 and all its needed software .NET and
Workflow foundation on Win Server 2003. The you need to install Beta 2 TR
whcih is not trival if you have no experience of the MOSS servers.
 
I owudl think Shamil Workflow with Access and MOSS would interest you. Its
very cool.
 
Martin
 
 
 
 
 
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
 
tel: 02890 974477
 

________________________________

From: accessd-bounces at databaseadvisors.com on behalf of Shamil Salakhetdinov
Sent: Wed 11/10/2006 17:10
To: 'Access-D'
Subject: [AccessD] Open Access 2007 forms and reports from WindowsSharePoint
Services



Hi All,

The following is a citation from MS Access 2007 online help:

<<<
Windows SharePoint Services users can open lists in rich Access views
directly from a SharePoint site. Office Access 2007 forms, reports, and
datasheets can appear listed alongside other views on a SharePoint site.
When you choose an Access view, Office Access 2007 starts and opens the
requested form, report, or datasheet. This makes it easy for you to run a
rich Office Access 2007 report on a SharePoint site without having to first
start Office Access 2007. You can also choose to open a list in Access, and
if a database doesn't exist, it is created automatically and prepopulated
with a set of forms and reports based on your list.
>>

Questions (to Martin probably):

How this feature works?
Is the database created "automagically" on client or on server side?
Does MS Access runs embedded in a host application (SharePoint services
client?) or as an independent application?
...

Thank you.

--
Shamil


--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/> 






More information about the AccessD mailing list