Sql server 2005 with ms access db

[Ashfaque]

Hi,

I used before MSDE SQL Server 2000 that is free of version of Microsoft for a single pc user.

I had kept my back end on this server and FE as Access db that was working smoothly thru ODBC linking tbl method. But all the tbls were become heavy gradually and it seems it decreased the speed that I was not expected.

I am planing to shift from the above server to SQL Server 2005 which I already installed on my laptop and connected to my Access db FE to SQL Server 2005 using same ODBC method and linked all tables.

But I do not want to use ODBC so that there will be no tbls displyed once you enter in the db.

I just want to connect the required BE tables when my db is opened and remove them back upon closing of db. This should help to reduce the db size as well.

So basically what I am looking for is connection string module code and also want to know how can I use it?

I have used a small connect string with .net project connected to SQL Server 2005 which is below.

Module ModConnection
Public Conn As New ADODB.Connection
Public Sub Connect()
Conn = New ADODB.Connection
Conn.CursorLocation = ADODB.CursorLocationEnum.adUseClient
Conn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;DSN=shhg"
Conn.Open(Conn.ConnectionString)
End Sub
End Module

May be it would be similar to this.

Can somebody help me?

Thanks for your time.

Ashfaque

 

[madEG]

Are you asking about not using ODBC at all, or about not using (ODBC) DSNs?

 

[Ashfaque]

I am asking not to use ODBC at all..in other words..no physical table should be displayed in db. All the activity should go thru codes only.

Thanks,