Feeds

Y2K bug lurking in Microsoft VB, Access

Woodwork, worms? But fix is at hand

  • alert
  • submit to reddit

Secure remote control for conventional and virtual desktops

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

Providing a secure and efficient Helpdesk

More from The Register

next story
The 'fun-nification' of computer education – good idea?
Compulsory code schools, luvvies love it, but what about Maths and Physics?
Facebook, Apple: LADIES! Why not FREEZE your EGGS? It's on the company!
No biological clockwatching when you work in Silicon Valley
Lords take revenge on REVENGE PORN publishers
Jilted Johns and Jennies with busy fingers face two years inside
Yes, yes, Steve Jobs. Look what I'VE done for you lately – Tim Cook
New iPhone biz baron points to Apple's (his) greatest successes
Happiness economics is bollocks. Oh, UK.gov just adopted it? Er ...
Opportunity doesn't knock; it costs us instead
Ex-US Navy fighter pilot MIT prof: Drones beat humans - I should know
'Missy' Cummings on UAVs, smartcars and dying from boredom
Sysadmin with EBOLA? Gartner's issued advice to debug your biz
Start hoarding cleaning supplies, analyst firm says, and assume your team will scatter
Edward who? GCHQ boss dodges Snowden topic during last speech
UK spies would rather 'walk' than do 'mass surveillance'
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.