MS Access Database (MDB) "read only" problem
Posted: Mon Jul 04, 2016 1:20 pm
HI,
I have a problem that seems very odd and hope someone (tech support?) has a solution. I have spent quite a bit of time diagnosing and recreating the issue.
Here are the facts.
1. I have a Native Engine install that among other things installs MS Access MDB databases (i.e. user.mdb).
i.e. Install Files D:\build\build2016\global\Database\user\userdb.mdb to $TARGETDIR$\Database\user
2. If I build the install as uncompressed (CD/DVD) the installation works fine with NO issues.
3. If I build the install as a single file (with minimal compression selected.. the 2nd tick mark)... the installation appears to work find EXCEPT that my MS ACCESS files as installed (target) have READ ONLY permission. Even though the source files are not READ only. This causes application problems.
4. As an aside... If change the NATIVE ENGINE to FALSE (MSI)... and install as a single file... the issue described in #3 above does not occur. All is fine.
I would like to know why #3 is occurring and how to fix it. There should be a way to have a single file installation in Native Engine mode without having the MS ACCESS (MDB) files having their access change to READ ONLY.
Thanks for any help.
George
I have a problem that seems very odd and hope someone (tech support?) has a solution. I have spent quite a bit of time diagnosing and recreating the issue.
Here are the facts.
1. I have a Native Engine install that among other things installs MS Access MDB databases (i.e. user.mdb).
i.e. Install Files D:\build\build2016\global\Database\user\userdb.mdb to $TARGETDIR$\Database\user
2. If I build the install as uncompressed (CD/DVD) the installation works fine with NO issues.
3. If I build the install as a single file (with minimal compression selected.. the 2nd tick mark)... the installation appears to work find EXCEPT that my MS ACCESS files as installed (target) have READ ONLY permission. Even though the source files are not READ only. This causes application problems.
4. As an aside... If change the NATIVE ENGINE to FALSE (MSI)... and install as a single file... the issue described in #3 above does not occur. All is fine.
I would like to know why #3 is occurring and how to fix it. There should be a way to have a single file installation in Native Engine mode without having the MS ACCESS (MDB) files having their access change to READ ONLY.
Thanks for any help.
George