run access 2016 in access 2007

[civl_eng]

hi all, i written a program in access 2016 now i want to run this database in access 2007 but i get this error : Unrecoginzed Access Database formatto



to fix this problem i wanted to save as (.accdb) to (.mdb) in access 2016 but i get error :



can someone help me?

[isladogs]

As the message is telling you, your database contains features that were not available in A2007 or in earlier versions where MDB files were used.
You will need to identify all such items and change or remove them.
Forget about converting to MDB. That format is less secure and will need more changes than A2007 ACCDB.

Start by looking at datatypes used for fields e.g bigint (large number) added in recent editions of A2016 and not available previouly

[civl_eng]

thanks a lot ridders52, i have another question, is there a way to enable all macro setting and activex by vba when access file is running ???

[isladogs]

Strangely, I posted a thread about this recently though only for ActiveX
https://www.access-programmers.co.uk...d.php?t=298496

BEWARE - These settings apply globally to all databases and indeed all Office programs

Basically it's a registry hack for ActiveX and almost certainly for macros
The consensus is that its a bad idea modifying other users' settings for fairly obvious reasons
If you MUST do it, then warn the user and give them the option to say no...then change the settings back when the database is closed

If it's just for you then change the settings in Access options yourself rather than write VBA to edit the registry

One other point. If you are using 64-bit Access in one version and 32-bit in the other, you will need to modify the code to manage that issue.