1. The answer must be able to accomplish goal without changing the Read/Write permissions of a source database NOR changing Read/Write in Destination database.
2. The solution must not include database security as part of the solution.
Can a linked table from one MS Access Database be made read only?
If a link can be established at the outset via VBA or after initially creating a link to a table the old-fashioned way THEN using VBA I will award points.
Note* I do not award points for "answers" that include solutions I have already stated I do NOT want.
More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…