You may be trying to access this site from a secured browser on the server. Please enable scripts and reload this page.
Turn on more accessible mode
Turn off more accessible mode
Skip Ribbon Commands
Skip to main content
Turn off Animations
Turn on Animations
SharePoint
Sign In
Use SHIFT+ENTER to open the menu (new window).
To navigate through the Ribbon, use standard browser navigation keys. To skip between groups, use Ctrl+LEFT or Ctrl+RIGHT. To jump to the first Ribbon tab use Ctrl+[. To jump to the last selected command use Ctrl+]. To activate a command, use Enter.
Browse
Tab 1 of 3.
List Tools
Items
List Tools group. Tab 2 of 3.
List
List Tools group. Tab 3 of 3.
Follow
GNRHS Research
Currently selected
GNRHS Research - new site in progress
Publications
GNRHS.org
Help
Team Discussion
Use the Team Discussion list to hold newsgroup-style discussions on topics relevant to your team.
It looks like your browser does not have JavaScript enabled. Please turn on JavaScript and try again.
AFEs, Blueprints, & more
JSRH Holdings
BN_Station_Plats
BN_Structure_Drawings
BN_BridgeAndBuilding
Enhanced_Drawings
GN_AFE_List
GN_AFE_Mattson
GN_Blueprint_AFEs
GN_JSRH_Blueprint_Collection
GN_Interlockings
GN_Locations
GN Employee Timetables
GN Public Timetables
GN_Valuation_Maps
GN_Valuations
RailroadForms
SPandS_AFEs
Photos
GN_Ainsworth_Diesel_Slides
GN_CascadeDivision
GN_Depots
GN_Keyes_Photos
GN_Misc
GN_Newby_Photos
GN_PR_Photos
GN_Stevenson_Photos
GN_Turner_Photos
GN_Werkema_Photos
GN_Will_Photos
JimParkerPhotos
T. R. Wahl Photos
Wilbur Shannon Photos
Wingfield_Photos
WFE/FGE/BRE
Recent
Currently selected
GN Clearance Diagrams
GN Standard Plans: Signals
GNRHS Access and Reproduction Policies
GN Timetable Scans
GN New TT
Site contents
Interfacing with MS Access
TRAINS2\jsotto
0
10/28/2009 2:04 PM
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
10/28/2009 2:04 PM