In an office with 6 users having no issues with a SQL database, one user is repeatedly getting errors. Al machines are XP, SP3, .net framework up to date.
The user is okay for several searches/queries but after a few times, starts getting SQL error about object reference not set to an instance. The database can be searched by name, customer type etc. The user selects a customer type from a drop down box and after a few successful uses, using any drop down box at all returns the same error.
Ex. Line 256 if dropdownlist2.SelectedIten.value = 0 Then Exit Function
However all others users using the exact same drop down box to select the exact same customer group has no issues. Again, this also works SOMETIMES for the user having issues, then gets kicked out and asked to login again or receives the above error. This one machine is new on the network and worked fine for her yesterday but has been failing repeatedly today.
Any ideas? is there perhaps an update needed to handle these scripts? It’s seems machine related not database, as others have no issues with the same search system.
Any other ‘local’ info can be provided if needed but the database is stored off site and was designed several years ago by a programmer who is no longer in the country.
Judging by the error it seems database related, but judging by the occurrence and isolation to a single machine, it is local.