Undefined function

  • Thread starter Thread starter Dogbert
  • Start date Start date
D

Dogbert

I am using Access 97. I have a query that selects records based on letters
in certain locations in the description using the Mid$ function. It has
always worked in the past. However, after I installed the latest update for
Access, whenever I try to run the query, I get "Undefined function 'Mid$' in
expression". The database is on a network server and the query works fine
for everyone else. I even tried to re-create the query using the Builder,
and got the same error. I think, somehow, the function itself is corrupted
on my PC. Is there a way to find out if I have a corrupted in my Access? I
have also tried the Mid() function with the same error.
 
I don''t have any modules being used. In fact, I have never used Modules
before in any databases. But, I told it to start a new module, and checked
references. The only ones checked are;
Visual Basic for Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applications Extensibility 5.3

I checked them, and through all the others listed, and none are marked as
"Missing".

I will check your links anyway, and post back.
 
I was wrong. I did check for references and all was fine. Then I noticed I
had opened the wrong database. I opened the one I am having a problem with,
and it lists "MISSING: utility.mda". I did what was suggested on
allenbrowne.com (searched for the file, browsed to the correct location,
unchecked the missing entry), and it works fine now.

Thanks, Cheryl.
 
Back
Top