How to unlock VBA Project?

[deko]

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.

[pietlinden]

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

[pietlinden]

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.

[deko]

> 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...

[deko]

> 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

[Randy Harris]

"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

[deko]

> 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.

[Michael \(michka\) Kaplan [MS]]

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.