The magic just worked today.

Here is the working code, problem lay in the name of Source !

Thanks for help everyone, I go there in the end !

Private Sub Command15_Click()

Dim...

I have replaced LOCAL with MSSQLSERVER2

Hi,

Yes here is you original code and it stop/timesout at 'open' as well

Private Sub Command15_Click()

Dim con As ADODB.Connection

Dim cmd As ADODB.Command

Dim rs As ADODB.Recordset

' DB Connect and query

'...

Thanks old hand.

Tried your code but without success. My sql server is loaded on my PC along with ma access.

I have no problems linking tables between SQL Server and...

Thanks, typed it in a hurry.

Will give it a go tomorrow and let you know !

Regards

Hi Guys,

That a good help, this is how far I have got tho from putting code togethermn, still not working !

Rem Open a connection without using a...

Thanks again SSCrazy.

I have linked tables working now between access 2993 and sql server 2008 and for me that's a big step forward.

Although all my tables are linked...

Hi,

Thats great, I am just getting it all togther and practicing with SSMS etc. I have my tables and realtionships created.

So in my Access databse I have form FrmClients...