Access 97 string functions 'broken' after windows upgrade

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nathan Holmes - 06 Feb 2005 23:15 GMT

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?

Reply to this Message

Albert D. Kallal - 07 Feb 2005 01:39 GMT

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

Reply to this Message

Allen Browne - 07 Feb 2005 13:29 GMT

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?

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message

Albert D. Kallal - 07 Feb 2005 20:38 GMT

> 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..

Signature

Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com
http://www.members.shaw.ca/AlbertKallal

Reply to this Message