Both frontend databases (.adp) are using Access 2010 yet one database won't allow me to Rename/Delete a module (see first attached file - DeleteRenameProblem) while the other database will (see second attached file - DeleteRenameOK). In fact both frontend databases connect to the same backend SQL 2008R database.
The first frontend database (the one that won't let me Rename/Delete a module) was originally developed under Access 2007 (.adp) and upgraded to Access 2010 (.adp).
The second frontend database was developed using Access 2010 (.adp).
I created a new frontend 2010 Access .adp database and imported all the Modules/Macros/Forms and Reports from the frontend 2010 Access.adp that won't let me Rename/Delete modules but I still come up with the same problem.
I also tried the Compact/Repair approach but ended up with the same result.
Can anyone tell me what is wrong with the frontend database that won't let me Rename/Delete modules and/or point me in the right direction as to where to look for a solution. (It appears it may have something to do with the upgrade from Access 2007 to Access 2010). I've looked on the internet but I can't find anything there either (maybe not asking the right question).
Many thanks in Advance - Michael