When I deploy a compiled database, I often rename the file extension to ACCDR to force Access into Runtime Mode. I use the following code to check if the database is running in Runtime Mode and exit the application if it is not.
SysCmd(acSysCmdRuntime)
However, I could not find an equivalent SysCmd constant to check for ACCDE, and I am not sure if there is a property for it as well. So, I came up with the following function, which seems to do the job.
Public Function IsACCDE() As Boolean On Error GoTo errHandler Application.VBE.CodePanes(1).Show IsACCDE = False errExit: Exit Function errHandler: IsACCDE = True Resume errExit End Function
I am not sure if it is the best way to perform the ACCDE check, but I just thought I would share it and see if you can tell me if there is a better way. Thank you!
Looks good to me! It either fails and "yes, I'm Run time" or succeeds and is full blooded Access.
ReplyDeleteHi Bogart,
ReplyDeleteThank you for your comment. Cheers!