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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.