Here's an example using Windows integrated security ...
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=Northwind;Data Source=(local)
.... and here's one using SQL Server security ...
Provider=SQLOLEDB.1;Password=YourPasswordHere;Pers ist Security
Info=False;User ID=YourUserID;Initial Catalog=Northwind;Data Source=(local)
There are many other variations possible, but for a typical installation onReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11760
your local PC one of these will probably work.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11760
"David Kennedy" wrote in message
> Hi ,
> I have Access 2000 and SQL Server 2000 on my PC.
> I am trying to connect an Access database to SQL Server 2000(local) using
> VBA code.
> I am having trouble with the connection string,I dont know the correct
> objConnSQL.ConnectionString = ??????
> can anyone help me with this?
> Thanks in advance,
> David K