I am using TransferSharePointList method to link SharePoint tables into access database. Can you pass user credentials in the connection string this way?
SharePoint developer with an overall of 6 years of experience varying from finance to service to core IT industrial projects. As per your requirement I had been catering such services in the organization for years. So choose wisely.... Your expectations my work.