I have a database front end that I have been using for several years without issue. I have always had no issue converting it to an MDE file and having all the VBA code work correctly.
After a long day of work on the Front end today I attempted to convert the database to an MDE file and found that none of the VBA code was working any more on the MDE version of the database. This is only a problem after converting to an MDE file. The MDB version works perfectly fine.
The following is what I have attempted to do to resolve this:
I attempted setting macro security to the lowest level.
I did a compact and repair on the MDB file.
I tested on multiple PC's, both the MDE files and converting the MDB to a MDE file.
Any advice would be appreciated.