How to access data in Access 2007 through Sharepoint

[A. J.]

I have an Access 2007 database created and ready to use.

I would like to use the Shareport as an interface and though it to access
the forms (input the data) and view the reports in the Access 2007 database.
Is that possible? And if yes, what is the way to do so?

 

[Chip]

I'm in no way an expert here, but I'm not quite sure its all that
easy. Its doable, and I've been trying to do that myself. Probably
through SharePoint designer. But I think the easiest soluton is to
switch to Office 2010 when it rolls out. I know they made a big deal
of showing off that capability on a webcast I saw. I showed it to my
managment and it sold them..

Can someone take an access form, run it through Sharepoint Designer
and then have it create the form for use on a SharePoint site?

chip

 

[GP George]

No, that scenario is not supported. Here's a very high level look at the
way this works in Access 2010.

You create the database using the web version of the Access tools (forms,
reports, etc.) All coding is done with macros, not with VBA.

You are then able to "publish" the Access application to your 2010
SharePoint site. Access Web Services runs the application on SharePoint.

Tables when published, are handled as SharePoint lists.

Here's a link the Access team blob where you can read more about it.

http://blogs.msdn.com/access/archive/tags/Access+2010/default.aspx


George

 

[George Hepworth]

Actually, that would be a "Blog", wouldn't it?

No, that scenario is not supported. Here's a very high level look at the
way this works in Access 2010.

You create the database using the web version of the Access tools (forms,
reports, etc.) All coding is done with macros, not with VBA.

You are then able to "publish" the Access application to your 2010
SharePoint site. Access Web Services runs the application on SharePoint.

Tables when published, are handled as SharePoint lists.

Here's a link the Access team blob where you can read more about it.

http://blogs.msdn.com/access/archive/tags/Access+2010/default.aspx


George

 

[A. J.]

Thanks for your advices!

We have a Sharepoint site in use, and try to through it to access the Access
2007 database program (like to way we access the Access 2007 program). I have
browsed the Access program on the Sharepoint site. When I open the Access
program from Sharepoint, there are two options, Read Only and Edit, first
option only can view, and Edit redirects the Access program to other location
to save. So we cannot actually access the Access program on the Sharepoint
site. Could you help for this? Many thanks!

 

[George Hepworth]

Sorry, I should have made it clear that the new web services for Access are
available in Access 2010, not in any earlier versions.

 

[A. J.]

Thanks for all your help!

 

[De Jager]

I have an Access 2007 database created and ready to use.

I would like to use the Shareport as an interface and though it to access
the forms (input the data) and view the reports in the Access 2007
database.
Is that possible? And if yes, what is the way to do so?

 

[joelgeraldine]

hj ;lk!jjj