SP3 and SR1 Access versions mid() chr() functions 1

[rainbowrabbit]

I have written an application in Access 2000 version SR1 on Windows NT. The office is being upgraded to Windows 2000 professional and office SP3.

When I have attempted to run the application on the new version of Access 2000 the application first complains about mid() functions not being recognized in the some of the queries.

It then complains about mid() functions not being recognised within the vba modules. When i try to compile the vba code it doesn't recognize chr() functions either??

The forms in the application all look different as well.

Does anyone have any ideas how I can mend it? If it's even possible to mend it?!!

 

[RickSpr]

In the VB Editor, check Tools | References. I think this is caused when a referenced library is marked "MISSING".

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[rainbowrabbit]

Thanks Rick. A missing reference to a Crystal reports dll was causing it!