Linked to SQL Server - ODBC Only? 1

[Stevehewitt]

Hi Guys,

We're planning to upsize our backend to SQL Server 2000, and currently I've just got linked tables via a ODBC connection.
My question is: is there anyway to have a native / built-in connection, as Access already has with it's own backend files?

I don't want to manually create a system DSN in ODBC for every client that I'll be installing the app on; and I can't think of a way to create one using the Access Developer Extensions / Package Wizard.

Either ideas appreciated.

Cheers,



Steve.

"They have the internet on computers now!" - Homer Simpson

 

[lupins46]

Look here for DSN-Less connections:

http://www.accessmvp.com/djsteele/DSNLessLinks.html

 

[Stevehewitt]

Spot on! Thanks very much lupins46

Cheers,



Steve.

"They have the internet on computers now!" - Homer Simpson