utility (UTILITY) project

[Christine from New Jersey]

A few days ago I noticed the following project in my Access Visual Basic
Window:

utility (UTILITY)

It contains 2 Microsoft Office Class Action Objects named:
Form_ad_frmAutoDial
Form_ZoomForm

and 5 Modules named:
SOA_Biff
SOA_Glob
SOA_Rtf
SOA_Txt
Utils

I cannot remove the project, and I cannot view or remove the objects, as the
project is locked.

I created a new database file and imported the tables from the original
file, but a few minutes later the "utility" project showed up again.

Recently I updated my Office software on the Microsoft site.

Is this project a virus of some kind?

Would appreciate any help provided.

 

['69 Camaro]

Hi, Christine.

Is this project a virus of some kind?

No. It's the Utility library in the Utility.MDA file that comes with Access
97 and earlier versions. Your database application has a reference set to
this library.

I cannot remove the project, and I cannot view or remove the objects, as the
project is locked.

The only way to remove this project is to remove the reference to this
library. If your VBA code is using this library, then removing this library
reference from your database application is not recommended.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

 

[Christine from New Jersey]

Thanks for responding. I checked my references and the reference to utility
was NOT checked. When I checked it, a folder named "References" appeared in
my project. When I remove the reference, the reference is removed, but the
project is not.

I noticed the acwzlib project is in the Project window also, even though
that reference is not checked.

These projects never appeared before, which is why I was wondering why they
would appear now. My code is very simple, with recordsets and SQL statements
that I've been using for quite some time. I have another database file with a
lot of code that is more complex, yet the projects do not show up in this
file.

I also feel the size of this database file is larger than it should be and
it takes too long to load. I will try to recreate the code in a new database
file and see what happens.

 

['69 Camaro]

Hi, Christine.

These projects never appeared before, which is why I was wondering why they
would appear now.

One doesn't need to explicitly set a reference via the References window in
order to add library references. A database application may acquire a
library reference via another library reference or even from the conversion
process from an earlier version of Access.

I also feel the size of this database file is larger than it should be and
it takes too long to load.

Often a compaction will fix a bloated database, but occasionally a
/decompile is necessary. When a database application takes too long to load,
then the database developer needs to take a closer look at possible
inefficiencies, including database structure, queries, use of subdatasheets,
VBA code, indexes, linked tables, multiuser connections and network and
workstation hardware.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.

 

[choy meng onn]

hi how to remove the ultility.MDA
can let me know the step??

as i am doing some conversion of access data 03 to 97
to suite with the usage of my VB project

not is the problem each time i open the file it show me another form or
table indicating conversion error.
i open it and it show broke link to UTILITY.MDA.

can give me some idea how to solve it?

url:http://www.ureader.com/msg/10592362.aspx

 

[John W. Vinson]

hi how to remove the ultility.MDA
can let me know the step??

as i am doing some conversion of access data 03 to 97
to suite with the usage of my VB project

not is the problem each time i open the file it show me another form or
table indicating conversion error.
i open it and it show broke link to UTILITY.MDA.

can give me some idea how to solve it?

url:http://www.ureader.com/msg/10592362.aspx

Type Ctrl-G to open the VBA editor.
Select Tools... References from the menu.
Scroll down and find UTILITY.MDA.
Uncheck the checkbox by it.
Select Debug... Compile and correct any VBA errors (you might be calling
something in that library database and will need to find some other way to do
it).