Feeds

Y2K bug lurking in Microsoft VB, Access

Woodwork, worms? But fix is at hand

  • alert
  • submit to reddit

High performance access to file storage

Some of the problems Web sites had ticking over successfully from 1999 to 2000 are likely to be caused by a Y2K bug in Visual Basic 3.0, as evidence emerges of Y2K problems with old versions of Microsoft Access 2.0. Although Microsoft has upgraded Visual Basic several times since version 3.0, the program was used for many years in large, medium and small businesses, as was Access. Laurence Rogerson, a consultant and director at Web firm Hubcom, said yesterday that he had encountered several Y2K related problems with version 3.0 of VB. He said: "If you open up the immediate window and type in ? Year("3/1/00"), it returns 1900". He said that testing he had performed on one application which was built with VB 3.0 and uses some old VBX support files, queried one database for names between October 1899 and January 1900. It then bombed out because none were returned, he said. Rogerson added that VB 3.0 was used in many corporate environments to develop applications. "It surprised me when I discovered the problem as I just assumed it would apply the current century to a two digit date but it seems that it doesn't," he said. "It works OK with a 4 digit year though, e.g.: ? Year("2/1/2000") => 2000 as does ? Year(Now())." He said: "I'm much more concerned with Microsoft Access 2.0 applications as this comes from the same time and suffers the same problem as well There are masses of those still around as the later versions just do not work with Windows 3." However, the situation may not be as black as it is painted. There are several references on the MSN site to problems with Access 2.0 for 16-bit Windows. The main reference can be found here, and according to a reader, Microsoft has fixes for the engines in both VB3 and Access. ® Our report on millennium tick-over problems

High performance access to file storage

More from The Register

next story
Dropbox defends fantastically badly timed Condoleezza Rice appointment
'Nothing is going to change with Dr. Rice's appointment,' file sharer promises
Audio fans, prepare yourself for the Second Coming ... of Blu-ray
High Fidelity Pure Audio – is this what your ears have been waiting for?
Did a date calculation bug just cost hard-up Co-op Bank £110m?
And just when Brit banking org needs £400m to stay afloat
MtGox chief Karpelès refuses to come to US for g-men's grilling
Bitcoin baron says he needs another lawyer for FinCEN chat
Zucker punched: Google gobbles Facebook-wooed Titan Aerospace
Up, up and away in my beautiful balloon flying broadband-bot
Apple DOMINATES the Valley, rakes in more profit than Google, HP, Intel, Cisco COMBINED
Cook & Co. also pay more taxes than those four worthies PLUS eBay and Oracle
It may be ILLEGAL to run Heartbleed health checks – IT lawyer
Do the right thing, earn up to 10 years in clink
prev story

Whitepapers

Top three mobile application threats
Learn about three of the top mobile application security threats facing businesses today and recommendations on how to mitigate the risk.
Combat fraud and increase customer satisfaction
Based on their experience using HP ArcSight Enterprise Security Manager for IT security operations, Finansbank moved to HP ArcSight ESM for fraud management.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
SANS - Survey on application security programs
In this whitepaper learn about the state of application security programs and practices of 488 surveyed respondents, and discover how mature and effective these programs are.