H
Henrik Rosenberg
We have an Access 97 solution, with a number of linked tables, passthrough queries, and reports. (but no local data)
The database is placed on a share, and used by users in different countries/units.
Each country/unit have (locally placed) customer sensitive data, used as part of the queries & reports.
PROBLEM: Access seem to cache data and save them in the .mdb file - meaning that one unit can (e.g. by opening the mdb in Notepad) see another units customer data, e.g. names.
Is is possible to avoid that Access saves data in the mdb file? (readonly is not an option).
I am not confident that the CacheSize property will PREVENT Access from saving the data.
The only other alternative I can see is to copy the mdb. to unit dedicated shares ...
The database is placed on a share, and used by users in different countries/units.
Each country/unit have (locally placed) customer sensitive data, used as part of the queries & reports.
PROBLEM: Access seem to cache data and save them in the .mdb file - meaning that one unit can (e.g. by opening the mdb in Notepad) see another units customer data, e.g. names.
Is is possible to avoid that Access saves data in the mdb file? (readonly is not an option).
I am not confident that the CacheSize property will PREVENT Access from saving the data.
The only other alternative I can see is to copy the mdb. to unit dedicated shares ...