Connection without ODBC

[hegartyjp]

Hello.

Would really appreciate some help with this.

Can anyone tell me if it is necessary to have an ODBC link set up on every PC where a user is going to access a SQL Server DB through Access.

There will be about 200 to rollout and I am praying there is some other way.

Please Help

Desperate...

Thanks in advance

 

[bborissov]

No, you could use ADODB to create connection and RecordSet.
Ask the same question in Access forum. I think there must be some DSNless connection type in Access if you want to use SPT and ODBC connection.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[bborissov]

No, you could use ADODB to create connection and RecordSet.
Ask the same question if Access forum. I think there must be some DSNless connection type in Access if you want to use SPT and ODBC connection.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[PeterHegRT]

Something I've noticed...
If you have a plain old linked table, and you set up the linked table with a dsn, the dsn information gets embedded into the linked table and the link will still work if you delete the dsn. And will work from any other PC.

Peter Hegarty (No Relation!)

 

[hegartyjp]

Peter

That actually sounds ideal but our policy does not allow linked tables in the databases.

Thanks though...

May come in useful elsewhere.


Bborissov. Thanks as well.

Will look into your suggestion and have posted on MS Access Forum.