I have a sharepoint 2010 list



access 2007 linked table to sharepoint list

macro in access to open query that will delete / full replace of a local table from the list
at this point in the query it requres a user and password for sp security

question how can i pre-populate and bypass the sharepoint authentication request user and password for sharepoint

i have a service account that i use just for data refresh, sftp, applications
user: Sv-bobjprod
pass: Static for 1 year