Hi,
I've got an Access db with some linked tables to a SQL Server db. I've set up an OLEDB connection to the Access db but I can't connect onto the SQL Server tables. The SQL Server uses SQL Server authentication. Any ideas on how I can connect to populate my dataset?
All help appreciated!!!
Craig
I've got an Access db with some linked tables to a SQL Server db. I've set up an OLEDB connection to the Access db but I can't connect onto the SQL Server tables. The SQL Server uses SQL Server authentication. Any ideas on how I can connect to populate my dataset?
All help appreciated!!!
Craig