I have a number of questions/issues coming up as I try to compile and publish my accdb database. I'd like to address them one at a time in this topic to avoid confusion. Here goes.
There are 3 files in this database, two front ends and one back end. I'll start with the one I am able to compile FrontEnd1.accdb. This compiles without any errors. When I try to open the ACCDE file I get the standard security notice.
"It is not possible to determine that this content came from a trustworthy source. etc. ..."
Well I know and trust the source, so I click open. The first thing I notice is different is all the check boxes, about 50 of them, are filled in solid instead of an empty white box. I am, however, able to check and uncheck them. When I do that they convert to a empty white box, like normal. I believe this may be caused by the following. Only the macro driven command buttons are working. None of the code driven buttons work. About 90% of this single form application is controlled with macros, but there are a few critical things are code driven. So that's the first thing I want to address. All these command buttons work just fine in the ACCDB file. I suspect the security settings need to be tweaked, but I'm not sure where to start.