Access/SharePoint Question

  • Thread starter Thread starter Lance McGonigal
  • Start date Start date
L

Lance McGonigal

Thanks in advance for your reponse.

I read in the Access Bible 2007 that access could use sharepoint over the
web. does this mean that access can use a sharepoint list over the web like
it uses sql server over a lan?

thanks
 
I am using Sharepoint lists in an application that I am developing, because
my superiors don't want to use SQL Server.

I have the lists linked into my Access application, and everything appears
to work smoothly.

The major down side is that sharepoint lists do not have referential
integrity, so you have to spend a lot more time (and code) making sure your
referential integrity rules are followed, and cleaning up tables when you
delete a record. Another issue is that your users will all have to have full
permissions for the page on which the lists are posted.

All you have to do to create the link in Access 2007 is select "External
Data", "Sharepoint" from the ribbon bar. Then type in the URL of the
Sharepoint page on which the lists exist. Click on one of the radio buttons
to import or link the lists, and click Next. A list of the lists on that
page will show up.

If you are working in Access 2007, and your Sharepoint administrator will
allow it, you can actually publish the Access application to Sharepoint, so
that your users can run the application from there. Unfortunately, my admin
policy prevents this, so I post the application to an FTP site where my users
download it.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top