calling data from SQL Server 2000

[JohnAcc]

Hi all,

I would like to retreive data from a table within SQL Server 2000. The problem I have is that my log in to SQL is different to my log in to windows.

What code do I need in vba to log in with my correct log in ?

Thanx in advance for your help.

Rgds, John

 

[fredericofonseca]

search these forums from ADO and connections and you will find load of threads with links to at least two sites full of Connections using ADO.

Then post your code if you still have problems.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com