"function isn't available in expression"...corrupted database?!?! 1

[storer]

I have a replicated database on an offsite computer. Reports with date functions in the query (i.e. <date()) and reports that are grouped by month based on a date get the message &quot;Function isn't available in expression in query expression...&quot; I had the gal make a new query and use the criteria date() in a date field and she got the same message. She also is getting an &quot;illegal operation&quot; error when she goes into a certain form but not other forms. Her computer is the server and others on the network do not get the illegal operation error but they do get the function not available error.
Here's the good part. I guess her computer crashed about a week ago when Norton utilities suggested letting the &quot;doctor&quot; clean up her hard drive. She did it while others where in the network and in the database. (Another person on the network complained about how slow the database was running.) Windows wouldn't restart, it couldn't find what it needed. I guess the company that services the computers came, transferred her files to another computer, installed a new hard drive and software on hers and transferred her files back.That seems to be when these problems started or at least she is certain that's when the illegal operation started...the other, she doesn't run reports that much so wasnt sure.

I had her run a query with Date() criteria in another database and it worked fine. So...is the one database corrupt?
I'm going to have her make a replica copy (her copy is a replica, the master is on my computer) and have run repair database function on it. Any other suggestions?

the computer person in my office said that she has heard, in the past, that Access was unstable and this type of thing happens more than one wants. Is that true? I really like access and haven't really had any trouble that couldn't be fixed. I assuming this happened because she ran Norton Doctor while others were in the network. Am I right?

I have been meaning to split this database (tables in one, rest in other) but haven't gotten to it. Wish I had now! and will soon as I can.

If datbase doesn't repair, can I import database into new table and maybe &quot;lose&quot; the corrupted part?

Thanks!

Maggie

 

[PaulF]

check for a &quot;Missing&quot; Library. Open a code module in Design mode, Click on the Menu: Tools then References
Look for any Library that has &quot;Missing&quot; associated with it. Then click on the checkbox next to this Library.

PaulF

 

[Rohdem]

Importing all objects into a new database is usually where I start when I have a database that has seemingly been corrupted beyond the point where the MS Access repair utility will work. You could take this opportunity to break apart the database. Import all the tables into one new database. Import everything else into another. When you are importing the objects the status bar tells you what object is being imported. This may help you pinpoint the 'problem object' if you get an error while importing. Also, if you haven't already, download the jetcomp.exe utility from Microsoft's website and run that on the database.
Mike Rohde
rohdem@marshallengines.com

 

[storer]

The repair utility didn't do the trick but importing into a new database did! Thanks.