Global Modules - cannot delete, rename, or cut

[jjlogan]

In my Access 2003 database, my global modules changed (by some process) so that I cannot delete, rename, or cut them out of the db. I want to delete them so I can import fresh copies from a save db.
Any understanding on this would be appreciated.
Jeff

 

[vbajock]

Sounds like you've got a rights-assignment issue and the mdb is read-only for some reason. Do you have a Network Admin you can have check the mdb to see if you have the proper rights assigned?

 

[jjlogan]

Thanks. I will check with network admin.
I am the one who creates and modifies the databases in our group and can usually delete any module I need to. But these global modules (about 5) cannot be deleted.
I just read advise on another blog (not TekTips) and was advised to decompile the database (which I did using c: prompt - but did not solve) or create blank database and import from a backup. This I did and am back in business; my tables fortunately were not affected. But what a mystery.
Jeff

 

[vbajock]

Are these "global modules" .MDA or .MDE (file extension) files? If it is .mda, you can rename it to a .mdb, make your changes, and then rename it back to a .mda. If they are .mde, you can't make any changes without the master database.

 

[jjlogan]

vbajock,
Don't know what you're referring to re mda. The modules I am taking about are in the mdb db under category "Modules". These are what I call global modules where I can store vba functions / procedures that are called from various form or report modules. J

 

[vbajock]

I'm talking about the file extension on the Access database. Usually it is .mdb

If it is a code library that can be used globally, it is will be .mda

In a .mda file, if you do not change the extension before you make changes, it will look like you can make changes, but it will not save anything you change. You have to rename the .mda to .mdb, make your changes, then name it back.

 

[jjlogan]

OK. Thanks for explaining mda's; maybe I could use one for by applications. Jeff

My problem is now solved. Thanks for your input.