PC Review


Reply
Thread Tools Rate Thread

Access 97 string functions 'broken' after windows upgrade

 
 
=?Utf-8?B?TmF0aGFuIEhvbG1lcw==?=
Guest
Posts: n/a
 
      6th Feb 2005
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 With Quote
 
 
 
 
Albert D. Kallal
Guest
Posts: n/a
 
      7th Feb 2005
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....nceErrors.html

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



 
Reply With Quote
 
Allen Browne
Guest
Posts: n/a
 
      7th Feb 2005
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?

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

"Albert D. Kallal" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 With Quote
 
Albert D. Kallal
Guest
Posts: n/a
 
      7th Feb 2005
"Allen Browne" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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..


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.members.shaw.ca/AlbertKallal


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
My Windows XP Upgrade CD got broken! =?Utf-8?B?VGV4YXpNYW1p?= Windows XP Help 2 13th Mar 2008 04:37 PM
Windows XP upgrade CD is Broken =?Utf-8?B?VGV4YXpNYW1p?= Windows XP Help 4 13th Mar 2008 04:36 PM
Access VBA mailmerge to Word broken in upgrade from '97 to 2003 =?Utf-8?B?U3RldmUgQ29tbWlzc28=?= Microsoft Access VBA Modules 7 6th Oct 2005 08:11 PM
String Functions in Access XP RCollinge Microsoft Access Queries 3 23rd Feb 2004 11:45 AM
String Functions in Access XP RCollinge Microsoft Access Queries 0 19th Feb 2004 11:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:05 PM.