Cannot key numbers into VB 3 Access 2 application
Posted on 2001-06-14
I'm supporting a VB3, Access 2.0 DB application in which a small percentage of users are unable to key numbers into several text boxes on screen, but they can key letters into any text box at any time. Tried keying numbers from both keyboard and number pad but nothing happens when a number key is hit. I have seen this issue with Win 95, 98, and 2000 workstations in stand alone, NT, and Novell environments. No pattern there.
In many of these cases Win 95/98 users have been able to get around the problem by going to Control Panel, System, Performance Tab, File System, and change the Typical Role of this machine between the "Desktop Computer" and "Network server." If problem comes up again can change setting back and it usually helps. Under Windows 2000 get same result by going to Control Panel; System; Advanced tab; Performance Options; under "Application response" change setting from "Applications" to "Background services."
This issue seems to be pc specific. In cases where program is run from a server if problem comes up on one pc we can immediately go to another pc and key numbers into the same field without any problems. On one pc with this problem we opened the Access 2.0 database directly (back door) and were able to key numbers directly into the table.
This issue has been a thorn in my side for over two years. I don't know why changing the system settings helps (keep in mind there have been a few cases where nothing helped). I would appreciate any ideas or sense anyone can make of this. Thanks!!