Can I link an Access2003 table to a Sharepoint List? (or display thedata some other way?) - 05-28-2009 , 11:54 AM
I've just "exported" a table as a list from Access2003 to Sharepoint.
And, I've discovered that it is a static list, not a proper link to
the actual table.
All I'm trying to do is display a log that's in Access on Sharepoint.
Nice and simple.
Just wondering what my options are. Are there 3rd party products that
will make a web part?
Re: Can I link an Access2003 table to a Sharepoint List? (or display the data some other way?) - 05-29-2009 , 04:35 PM
Well, Sharepoint - shares files. You upload a file which can then be
viewed or downloaded by users. If you want to display the active
contents of you Access table you would have to develop an asp or asp.net
web page which would connect to the Access mdb to display the active
real time content of your table.
*** Sent via Developersdex http://www.developersdex.com ***
Re: Can I link an Access2003 table to a Sharepoint List? (or display the data some other way?) - 05-30-2009 , 12:44 PM
"jonceramic" <jonceramic (AT) gmail (DOT) com> wrote
SharePoint, I'm not sure why you're saying it's static? Perhaps your
original table did not have an autonumber column?
Both access 2003 and 2007 can link to SharePoint lists, and you can also
export the data to SharePoint and then from inside of MS access you can link
to that table. Once you link to that SharePoint list , then it will very
much behave like any other table. Even you DAO code and update queries will
work on that SharePoint list.
In your chase, it is possible that you did not have a autonumer column
before you exported. So, delete the link and the SharePoint list, add an
autonumber column to your table, and try exporting again. You should be able
to edit that list with access after, and also you should be able to
open/view/edit that table directly on the SharePoint site with your web
browser. So, anyone with an internet connection and ms-access installed
should be able to edit/view the data from within access. And, even if you
don't have access, you can open/view/edit the list from the web.
here's a video that explains it shows some of the options and possibility
that opens up with SharePoint:
The above is for a2007...but, it gives the general idea as to how access and
SharePoint can work together.
table when moved to SharePoint can be viewed and edited with a browser if
you open that list on the SharePoint site......
Yyou can also place a copy of your access database on the sharepoint site,
and that way all users can easily get a copy of your front end if they need
something more than just a table view like sharepoint gives you.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com