Project Unviewable in Access

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
 
T

Tony Toews [MVP]

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?

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/
 
M

MentalDrow

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...
 
Joined
May 7, 2008
Messages
2
Reaction score
0
I have the same problem and have tried for hours to solve it with no joy.

Regards,
Brian
 

ers

Joined
Jul 22, 2008
Messages
1
Reaction score
0
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
 
Joined
May 7, 2008
Messages
2
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top