Access 97 string functions 'broken' after windows upgrade

[Guest]

I have an Access 97 (yes, still) application which was developed on a Windows
NT machine. I've upgraded my development PC to Windows XP and now I'm getting
errors wherever the Format(), Left(), etc. functions appear in reports.

I'm sure I've had something very similar before (possibly with Excel) and
the solution was to clear and reinstate the VBA reference because it was
something to do with broken binary compatibility on the related DLL, but of
course Access 97 won't let you drop a built-in reference.

Can anyone please suggest a fix?

 

[Albert D. Kallal]

Common problem.

The issue is broken refs, you can find a soltion here:
Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html

 

[Allen Browne]

Hey, Albert, the pigpond address doesn't work any more.
Best one to use is:
http://allenbrowne.com/ser-38.html

Do you have a permanent home for your Access stuff yet?

 

[Albert D. Kallal]

Hey, Albert, the pigpond address doesn't work any more.
Best one to use is:
http://allenbrowne.com/ser-38.html

Do you have a permanent home for your Access stuff yet?

No, but am close to setting up my own server + permanent web address..