help! My access is broken

[jonnycattt]

Greetings.

I usually work on Access97, but I had to take a database file to another computer, which runs only Access 2000. So I had to convert the database, work on it, and then convert it back to Access97. Upon opening the database again in Access97, I now have trouble with any queries using certain functions. So far, the left() and right() functions seem to be broken. They simply do not work! I get an error saying that the expression is too complex, even though the same query worked before I converted the database to Access2000 and back again.

Any advice?

 

[Jeff Bailey]

It looks as if you have some incorrect or missing references. Open up any module in design mode (or create a new one - you won't have to put anything in it). Click on the Tools menu and select References. Look for any that state 'missing'. You will have to scroll down the list and select the reference that's gone adrift, (or the version you have on your current machine). Click on OK etc. to back out.

Jeff Bailey

 

[The_Doc_Man]

This is almost certainly some sort of references problem.

From the module pane, open any module (including a New one that you won't save if you don't want to). When the Menu Bar changes to the Module Menu, follow path

Tools>>References

In the rather complex list box that is displayed as a result of that action, you will see a checkbox and a module name. If you select a row in the box, the file spec for that row will appear at the bottom of the dialog box.

You want to find out if any of the names that are checked have the word MISSING (it will be in all caps) before the module name. Uncheck that name, then search for a module with a name close to that one using the Browse function. The most likely culprit is that to get it to work in AC2K, you had to update the DAO library.

Well, at least in some cases, you have to step back to the old libraries when you step back in Access. So DAO36.TLB has to step back to DAO35.TLB, etc.

If you can find the required older versions, double-click them in the Open dialog (that opened when you started Browsing), or click the file once and click the Open button. That will re-add the reference.

 

[jonnycattt]

Perfect. Thanks all.