[AccessD] Open Access 2007 forms and reports from WindowsSharePoint Services

Martin Reid mwp.reid at qub.ac.uk
Wed Oct 11 11:40:28 CDT 2006


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