Programmatically querying a linked Sharepoint list

[Guest]

I have an Access 2003 update query which updates a linked Sharepoint list
with information from a linked SQL table. The Sharepoint list is on a site
that requires login so when I run the query manually it challenges me with
website credentials, which I provide manually.

I want to run this query programmatically and schedule it to run several
times a day but I do not know how.

 

[Joshua A. Booker]

If the machine running the Access app has the SharePoint site listed in the
IE Trusted Sites Zone then you should not get the login prompt from Access.

HTH,
Josh

 

[Guest]

That by itself did not work.

Maybe its failure has as much to do with how I am trying to rerun the query.

I have created a DTS package that runs a SQL command of 'Select * from
QUERYNAME'. Since it's an update query, this script does not return any rows.

Is there a better (successful) way this could be programmed?

Many thanks,

 

[Joshua A. Booker]

Depending on the type of authentication specified in IIS on the sharepoint
server, trusted zones might not solve this.

I would try a linked table in Access to the sharepoint list and update that
table using an Access Update Query.

HTH,
Josh