By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,287 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,287 IT Pros & Developers. It's quick & easy.

How to unlock VBA Project?

P: n/a
I came across a VBA Project that I didn't know was part of my database until
I found it in Project Explorer (View > Project Explorer from the VBA IDE)
while doing some work recently. When I tried opening it, or viewing
properties, I get a "Project Locked" dialog that says "Project is
unviewable".

If I expand the project in Project Explorer, I can see a couple of forms and
some other stuff that I think are classes. But the stuff is simply
unrecognized - I don't know where it came from and it's not used anywhere.
My guess is a previous developer did something to put there.

Can someone tell me how to unlock or delete this project?

Thanks in advance.
Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
you do that and anything in your database depending on it won't work
right any longer... is that okay?

Nov 13 '05 #2

P: n/a
you do that and anything in your database depending on it won't work
right any longer... is that okay?

That's almost like saying "I don't know what this large round thing on
top of my engine does. Is it okay if I cut it off and throw it away?"
I guess you could do it - at your own peril, anyway.

Nov 13 '05 #3

P: n/a
> That's almost like saying "I don't know what this large round thing on
top of my engine does. Is it okay if I cut it off and throw it away?"
I guess you could do it - at your own peril, anyway.


I'm positive it's not needed. And I've got a back up.

I don't understand why or how it's locked, or how to remove it. There must
be a way...
Nov 13 '05 #4

P: n/a
> That's almost like saying "I don't know what this large round thing on
top of my engine does. Is it okay if I cut it off and throw it away?"
I guess you could do it - at your own peril, anyway.


funny... it's gone now. must have been something Access created on the
fly... ghost in the machine
Nov 13 '05 #5

P: n/a
"deko" <www.clearpointsystems.com@use_contact_form.com> wrote in message
news:5k*****************@newssvr21.news.prodigy.co m...
I came across a VBA Project that I didn't know was part of my database until I found it in Project Explorer (View > Project Explorer from the VBA IDE)
while doing some work recently. When I tried opening it, or viewing
properties, I get a "Project Locked" dialog that says "Project is
unviewable".

If I expand the project in Project Explorer, I can see a couple of forms and some other stuff that I think are classes. But the stuff is simply
unrecognized - I don't know where it came from and it's not used anywhere.
My guess is a previous developer did something to put there.

Can someone tell me how to unlock or delete this project?

Thanks in advance.


When you use the Access wizards, extra projects appear in the project
explorer. Their behavior is exactly as you describe (Project is unviewable).
They'll go away when close Access, not reappear until you use the wizards
again.

HTH,
Randy
Nov 13 '05 #6

P: n/a
> When you use the Access wizards, extra projects appear in the project
explorer. Their behavior is exactly as you describe (Project is unviewable). They'll go away when close Access, not reappear until you use the wizards
again.


It's not a good feeling to see "phantom" code in my database. At least now
I know what's going on.

Thanks for the tip.
Nov 13 '05 #7

P: n/a
With that said, there are two approsches one can take:

1) One can ask people if they know what the extras objects are, giving their
names explicitly?

2) Once can try to delete what one does not understand.

There is a clear flaw in the logic of #2. Please consider #1 next time, just
in case what you try and delete is important and you succeed....
--
MichKa [MS]
NLS Collation/Locale/Keyboard Technical Lead
Globalization Infrastructure, Fonts, and Tools
Microsoft Windows International Division

This posting is provided "AS IS" with
no warranties, and confers no rights.
"deko" <www.clearpointsystems.com@use_contact_form.com> wrote in message
news:2h*****************@newssvr21.news.prodigy.co m...
When you use the Access wizards, extra projects appear in the project
explorer. Their behavior is exactly as you describe (Project is unviewable).
They'll go away when close Access, not reappear until you use the wizards again.


It's not a good feeling to see "phantom" code in my database. At least

now I know what's going on.

Thanks for the tip.

Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.