Access2000 Pro update query problem

[Anon]

Hi,

The cbo queries I have been using together with forms in Access97 don't work anymore in the Access2000 Professional that has been distributed on my work via the network.
The database was converted to the Access2000 format.

Example criteria used in a Query:

[forms]![AA_AI_RatForm]![cbonucleotide] or [forms]![AA_AI_RatForm]![cbonucleotide] is null

Strange enough in the Access2000 Premium I've installed at my home these queries and forms are still working like in Access97.

Is there something wrong with the version that was distributed via the network at my work?
Our network administrators don't know either.

Jaap van Eendenburg
LUMC
Leiden
The Netherlands

[bastien]

I have the same problem converting from Access 97 to 2000 Pro.

When you convert you will have to go to any Visual basic module, select tools-references. You will no doubt need a reference to MS DAO 3.6 Object library in order for the new database to compile. You may have to adjust its priority (move its order up or down in the "stack" of references.) You might first look at the order of things in your 97 version, then make the 2000 and try to duplicate it. Remember 8.0 in 97 becomes 9.0 in 2000 and 3.5x becomes 3.6. (you get the idea). 🙂

If you're not Dutch, you're not much!

Greeting from Canada

Bastien