Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create a Read Only link to a SQL server database 1

Status
Not open for further replies.

zai800

Technical User
Apr 25, 2003
1
IE
I need to link tables on an MSSQL database to a access database. The MS SQL ODBC driver that is supplied does no have a Read Only option. Is there another ODBC driver that I could use.
 
The ReadOnly feature is normally set on the "Recordset" object in DAO or ADO. Another way to get ReadOnly capability is through Access security. You'll need to set up an Access security workgroup with a Group that has Read Only access to the tables, and then require your users to login to the secured database.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top