How do I manage linked tables using Microsoft Access security?
The main issues involved here are: • Providing users with sufficient permissions for them to connect or reconnect their application to the back-end database. • Resolving the differences in permission settings between tables in the front- and back-end databases. Four techniques are available to change a back-end connection: • Use the RefreshLink method after altering the connection string for a TableDef. • Use the TransferDatabase command to link the back-end tables. • First delete the existing link and then re-add it with the new connection string by using the Connect property of a TableDef object. • Use the Linked Table Manager (in Access 2.0 this is called the Attachment Manager) Although the use of RefreshLink probably seems the more “elegant” solution, it has the drawback of requiring Read Data permissions on the back-end base table in order for the user to be able to execute the method. For instances where the only access is to be provided by RWOP queries, the re-creation of the c
Related Questions
- Does Microsoft Access security still work if I use OLE automation or Microsoft Query to manipulate Microsoft Access tables?
- Is the Logitech Digital Video Security system compatible with Microsofts Vista operating system?
- Does Password-By-Phone.com also trigger Microsoft security warnings like dialers?
