Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Access 64 bit & 32 bit ACCDE file creation

Hi
In creating an ACCDE file in Access is it possible to specify that it should be for a 32 bit or 64 bit machine? So I want to create one file for each
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Thanks for the information. Microsoft don't make it easy
You can program your startup to enforce the runtime even if a user changes the extension from .accdr to .accdb.
Take a look at https://www.devhut.net/2010/11/01/ms-access-determine-if-runtime-or-full-version/  
or
https://stackoverflow.com/questions/20570928/how-to-determine-runtime-environment-in-microsoft-access-vba

You can have your startup code shut the app down if it is not opened in runtime mode.
Another option to protect your code is to put a password on your VBA project.  (Not the same as putting a password on the db file.)  Take a look at:
https://www.microsoft.com/en-us/microsoft-365/blog/2010/06/28/power-tip-password-protect-your-vba-project/