Search results

Yes - you are right ! Didn't realize that this property exists only in a compiled version... Thanks so much !

Is there way to create a macro through VBA ? E.g. currentdb.CreateMacro "mcrName", "mcrArguments", etc. The reason being is macro incompability between 2007 and 2010, so we need to create separate macros just before rollout. Thank you.

Unfortunately, this does not work in 2010 or 2007 - there is no such property, so function resumes on error without returning a result. Thanks for trying anyway!

Thanks for the idea - but .Properties("MDE") returns an error in Access 2010, not sure about Access 2007 though.

Already done - but a malicious user may rename ACCDE to ACCDB to circumvent the code. That is why we need to ensure that a user has opened the compiled version. Thank you.

Good morning. I need to determine whether a user has opened an ACCDB or ACCDE version of the database. I understand that SYSCMD is the right way to do it. I've created a test function below, however, it returns 'False' in both ACCDB and ACCDE versions of the database. Any suggestions are...