Hi John & sturner,

John's way is what I believe to be the standrard way, adding non client data to the tbl Client, but surely this breaks the rules of data...

Hi,

Good advice was reappraising the size of tables and I think one table could have 500,000 records after 5 years.

But still think the free version of Sql server will do...

Yes green and wet behind the ears!

But maybe i didn't explain it right i am familiar with the object orientated programming paradigm, i understand the principles behind encapsulation too.

I...

Hi

I currently login in as admin which has sa right and everything works perfectly but the error still arises everytime I open ssms!

Excuse my ignorance should i connect as sa?,

Hi SSCoach

Can you explain a little more, excuse my.igborance but what do you by objrct do you mean recordset type? or table?

Kind regards

😀

No thank you.

But now that I can view my tables, my next questions is how do I update my records !

I think I would do one at a time but...

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...