473,730 Members | 4,274 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to unlock VBA Project?

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
7 21852
you do that and anything in your database depending on it won't work
right any longer... is that okay?

Nov 13 '05 #2
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
> 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
> 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
"deko" <www.clearpoint systems.com@use _contact_form.c om> wrote in message
news:5k******** *********@newss vr21.news.prodi gy.com...
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
> 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
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.clearpoint systems.com@use _contact_form.c om> wrote in message
news:2h******** *********@newss vr21.news.prodi gy.com...
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
4545
by: John | last post by:
I've got multiple threads and processes that write to same file. Before writing all threads / processes first lock part of file and then write to file. If one thread / process locks file, another threads / processes can not lock this file again. And I want that all threads / processes wait until first thread frees lock by calling FileStream.Unlock. But I do not know what code should I use that all threads / processes wait until first...
1
1291
by: Shlomo Anglister | last post by:
Hi, How can I unlock stdio streams? There used to be an unlock API, what happened to it? I will appreciate any kind of help. Thanks, Shlomo
1
3197
by: deko | last post by:
Is there a way to unlock a table so a subroutine can complete? frmMain!frm0 has got a lock on a table I need to do stuff with. Error Number 3211: The database engine could not lock table 'tblRecords' because it is already in use by another person or process. I've tried this: HandleErr: Select Case Err.Number
2
3878
by: Unlock | last post by:
Greetings, Any expert able to help me to unlock the database at http://www.generate.netfirms.com/cgi-bin/to.cgi?l=res04 You will need to download the database which I have compressed into a zipped file (88MB). With the database unlocked, I could then use MS access to do customised searchings on any particular fields.
1
1380
by: M.C | last post by:
Following is a snap-shot of compiler created code when using UEM, use /Fx: struct __EventCriticalSectionStub { void Lock() {} void Unlock() {} }; ....
1
1472
by: Norman Yuan | last post by:
In my cuurent ASP.NET project, a weird thing happens: when I test-run the project and a uncatched run error occurs, VS quits the test-run, as expected. If I try to run the project again (either start it inside VS.NET or directly call the page from IE), I get server error, pointing to "machine.cofg" file at following portion: <compilation ...> <compilers> ... </compilers>
2
1347
by: Mitch | last post by:
Would anyone have a routine kicking around that would take a users email address and convert it into a string of numbers to use as an unlock code? I am writing an application and would like it to be demo'able but not fully functional until the unlock code is entered. thanks in advance! mitch
3
2455
by: m | last post by:
Hi, I'm running MySQL (5.0.18-nt) on WinXP with latest patches. I've some SQL code that generates an 'ERROR 11' in two different places depending on how the code is submitted. At the moment I'de like to find out what is causing the error, so I haven't included the code, which is quite lengthy. I'm not a MySQL (or anyother db) expert, but I've turned on isam logging and run the myisamlog utility which didn't seem to be the right
0
1466
by: Petra | last post by:
Hi! I don't know how to handle the following problem: When a User clicks on the detail view of an item, I lock the item in the database. If the user exits with clicking the cancel or ok button I unlock the item and everything works fine. But if the user exits just closing the explorer window or clicking on an other menu item in the frame, the item is still locked. I tried to load an aspx script which unlocks the item in the unload...
0
8943
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9442
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9229
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9176
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8184
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6725
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4543
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4801
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2175
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.