Relinking Acess to Sharepoint Tables

[technician]

Hiya All

I am in need of some help

I have a table located on a Sharepoint website

In Access 2003 I have linked the list / table to the Database

When I open the datebase, If i click on the linked table, access requests the username and password for the sharepoint site

once the password has been input, and connection established to the sharepoint site, i can open the Table and amend .

How can i automate this process for any linked tables to a sharepoint site?

Cannot seem to find any references anywhere for relinking to sharepoint sites


Thanks in advance

Paul