Today's stumper question:
I have a database of moderate complexity that compiles fine, but which I cannot save out to ACCDE. I get the message, "Microsoft Access was unable to create the accde, mde, or ade file."
I have tried importing everything into a blank database, resetting the options, and re-compiling, which I can do successfully, but I still get the same message when I try to save to accde.
The file has the same references as several other databases which I have saved successfully out to accde. I am using Windows 7, 64-bit, Access 2010, the tables are connected SQL tables using Native Client 10 (other dbs using the same thing with connected SQL saving out to accde just fine).
Please, someone ...