Adlerm
asked on
Cannot Rename and / or Delete a module in Access 2010 project (.adp)
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
ASKER
yes
Sorry for the delay in getting back to this.
I could not think of anything off-hand that would account for this, so I wanted to try and duplicate if possible.
I was unable to and can't even come up with anything out side of database permissions that might be related to this.
Do you have a sample of the file I can look at? if not, is it only the one module that you can't rename, or is it everyone?
Jim.
I could not think of anything off-hand that would account for this, so I wanted to try and duplicate if possible.
I was unable to and can't even come up with anything out side of database permissions that might be related to this.
Do you have a sample of the file I can look at? if not, is it only the one module that you can't rename, or is it everyone?
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No harm, no foul for a goose chase....we've all been there.
Normally I'd add that you should give an assist for anyone that helped get you there, but I don't even think I managed to do that.
Best part; I learned something new today<g>.
Jim.
Normally I'd add that you should give an assist for anyone that helped get you there, but I don't even think I managed to do that.
Best part; I learned something new today<g>.
Jim.
ASKER
I actually solved the problem myself - after several hour using a trial and error approach.
Initially I thought the problem only related to Modules but in fact it affected all the other database objects.
As it turned out the reason why I kept getting the problem was because every time I loaded the application it executed the autoexec procedure which in turn executed a Lock Navigation Pane command.
I narrowed down the problem by creating an new 2010 Access.adp frontend database, imported the modules and then imported the other database objects (Macro, Forms, Reports) one object type at a time but each time checking the sub menu to see if the sub menu Rename/Delete options were available.
All was OK until I close the application and then reopened it.
This indicated that something was amiss during the Load process which in turn lead me to investigate the Autoexec procedure. After stepping through the Autoexec process it became pretty apparent where the problem was occurring.
I'd still like to go on record and thank Jim for his time and efforts. I didn't give him much to go but at least he tried.
Initially I thought the problem only related to Modules but in fact it affected all the other database objects.
As it turned out the reason why I kept getting the problem was because every time I loaded the application it executed the autoexec procedure which in turn executed a Lock Navigation Pane command.
I narrowed down the problem by creating an new 2010 Access.adp frontend database, imported the modules and then imported the other database objects (Macro, Forms, Reports) one object type at a time but each time checking the sub menu to see if the sub menu Rename/Delete options were available.
All was OK until I close the application and then reopened it.
This indicated that something was amiss during the Load process which in turn lead me to investigate the Autoexec procedure. After stepping through the Autoexec process it became pretty apparent where the problem was occurring.
I'd still like to go on record and thank Jim for his time and efforts. I didn't give him much to go but at least he tried.
Jim.