Skip Ribbon Commands
Skip to main content
SharePoint

Skip Navigation LinksTeam Discussion : Interfacing with MS Access
Use the Team Discussion list to hold newsgroup-style discussions on topics relevant to your team.

Started: 10/28/2009 2:04 PM
Picture Placeholder: TRAINS2\jsotto
TRAINS2\jsotto
Interfacing with MS Access
Create Access Table from SharePoint List  2009-10-28
 
As advertised, in the SharePoint List I selected the option to create an Access table linked to the SharePoint List  and was quickly presented with a new table in a new Access database on my PC with a copy of the SharePoint List data on my screen. The links back to the aperture cards on the website were live and worked perfectly.
 
A great way to then use Access as a report writer to organize and format the data for nice presentation.  I'll try that in the near future, as I should be able to place the report on the SharePoint site and another Access user could run it from the website.
 
Jeff Otto
Picture Placeholder: TRAINS2\jsotto
  • TRAINS2\jsotto
/_layouts/15/images/person.gif" alt="Picture Placeholder: TRAINS2\jsotto" />
TRAINS2\jsotto
Create Access Table from SharePoint List  2009-10-28
 
As advertised, in the SharePoint List I selected the option to create an Access table linked to the SharePoint List  and was quickly presented with a new table in a new Access database on my PC with a copy of the SharePoint List data on my screen. The links back to the aperture cards on the website were live and worked perfectly.
 
A great way to then use Access as a report writer to organize and format the data for nice presentation.  I'll try that in the near future, as I should be able to place the report on the SharePoint site and another Access user could run it from the website.
 
Jeff Otto
010/28/2009 2:04 PM10/28/2009 2:04 PM
There are no items to show in this view of the "Team Discussion" discussion board.