how do i automate Sharpoint list updates

M

MNS

Can anyone tell me how i automate a scheduled update of a Sharepoint list
from an Access Database source?
 
A

Albert D. Kallal

MNS said:
Can anyone tell me how i automate a scheduled update of a Sharepoint list
from an Access Database source?
Click to expand...

You might expand on what you mean by "automate".

If you have a accDB with simple linked tables to SharePoint then any code or
sql updates you "run" in your application will update the tables in
SharePoint.

I don't really think there is a difference of issue if your access
application is connected to a back end accDB file or connected to sql
server, or connected to SharePoint.

You can simply schedule to have your application launch, and run some code
of your choice by using the windows task scheduler. I explain how to do this
here:

http://www.members.shaw.ca/AlbertKallal//BatchJobs/Index.html
 
A

a a r o n _ k e m p f

uh, you really should use XML and talk to the sharepoint server
directly.

I've done a lot of Access--> SharePoint over the years.
and it's just plain-- not fast enough- for real world usage

I think that it's too bad-- if MS took SharePoint and Access
performance seriously-- then maybe they should have looked at that a
decade ago.
But as it stands, it's not 1/2 as fast as it needs to be (because Jet
is a bloated pig of a database)

-Aaron
 
Top