Feeds

Y2K bug lurking in Microsoft VB, Access

Woodwork, worms? But fix is at hand

  • alert
  • submit to reddit

The essential guide to IT transformation

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

Boost IT visibility and business value

More from The Register

next story
6 Obvious Reasons Why Facebook Will Ban This Article (Thank God)
Clampdown on clickbait ... and El Reg is OK with this
No, thank you. I will not code for the Caliphate
Some assignments, even the Bongster decline must
Fast And Furious 6 cammer thrown in slammer for nearly three years
Man jailed for dodgy cinema recording of Hollywood movie
Caught red-handed: UK cops, PCSOs, specials behaving badly… on social media
No Mr Fuzz, don't ask a crime victim to be your pal on Facebook
Barnes & Noble: Swallow a Samsung Nook tablet, please ... pretty please
Novelslab finally on sale with ($199 - $20) price tag
Ballmer leaves Microsoft board to spend more time with his b-balls
From Clippy to Clippers: Hi, I see you're running an NBA team now ...
Video of US journalist 'beheading' pulled from social media
Yanked footage featured British-accented attacker and US journo James Foley
Call of Duty daddy considers launching own movie studio
Activision Blizzard might like quality control of a CoD film
Primetime precrime? Minority Report TV series 'being developed'
I have to know. I have to find out what happened to my life
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
Endpoint data privacy in the cloud is easier than you think
Innovations in encryption and storage resolve issues of data privacy and key requirements for companies to look for in a solution.
Scale data protection with your virtual environment
To scale at the rate of virtualization growth, data protection solutions need to adopt new capabilities and simplify current features.
Boost IT visibility and business value
How building a great service catalog relieves pressure points and demonstrates the value of IT service management.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?