Project Unviewable in Access

  • Thread starter Thread starter MentalDrow
  • Start date Start date
M

MentalDrow

I'm trying to add some features to a .mdb. A previous user who is no longer
contactable has somehow locked the VBA projects. What do I need to do to
unlock it. I've seen different ways of doing this for Excel but so far have
not seen it for Access. Can anyone help me with this?

Chaz
 
MentalDrow said:
I'm trying to add some features to a .mdb. A previous user who is no longer
contactable has somehow locked the VBA projects. What do I need to do to
unlock it. I've seen different ways of doing this for Excel but so far have
not seen it for Access. Can anyone help me with this?
Click to expand...

What messages or symptoms are you seeing? Please explain more what
you mean by locked? If it's asking you for a password I'd suggest
asking your corporate legal department to contact the user.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
I'm sorry, I was in a hurry while typing this. What happens is, I can get
into the VBA editor via Alt+F11 but if I try to open any of the projects I
get a message with title bar = "Project Locked" message = Project is
unviewable". I can see a list of all the projects in the project explorer
window but I can't open any of the projects to view/edit them. There is no
password protecting the projects. I'm assuming there is a setting I am
missing that will make the projects viewable.

Unfortunately the organization is a military one and the person in question
retired some years ago.

Thanks again for your help...
 
I have the same problem and have tried for hours to solve it with no joy.

Regards,
Brian
 
My experience

I had the same problem. After looking around a little, I found that the access database I was trying to use did not actually contain any of the code. In my case, the code was contained in another database in a different folder.

I would suggest that you may want to search around and see if you find a likely database.

Edward
 
Hi Edward,

I never found a solution, I simply recreated the DB form a backed up copy and reentered missing data. I think at some point I must have saved the DB in the wrong format.I now make sure that the backup DB is current and stored in a safe place. Unfortunately the transition from one version of MS Access to another always seems to cause untold hastles.

Thanks anyway for your reply.

Regards,
Brian
 
Back
Top