It was just reported that the users are receiving this error after login attempt "Index or Primary Key cannot contain a Null Value". I am running version 3.5 any assistance wll be appreciated since my users are dead in the water.
Kenneth Newman
4/1/2009 4:39 AM
Did you ever open and modify FileVista.mdb with Microsoft Access?
Cem Alacayir
4/14/2009 5:46 PM
No, I did not. However, When I got with my Sys admin team to check the logs of the server, it was reported that there was an I/O error. I copied the .mdb file and opened it with MS access to see if it is even readable, and it was. As a test I restored a previous version of the .mdb file (about 3 days old) and setup an eval site pointing to the same root structure and was able to login. I have sent an email to the customer explaining that there maybe a potential Database corruption and that a restore from a previous version would alleviate the login issue, user accounts created after that date of restore would have to be recreate. I Am awaiting a response.
Kenneth Newman
4/15/2009 4:59 AM
You should try to fix the current database file by using "Compact and Repair" feature within MS Access.
Cem Alacayir
4/15/2009 5:28 PM
Yeah, I tried that earlier on in my troubleshooting and it did not resolve the issue. So I had to settle with a restore.
Kenneth Newman
4/17/2009 4:50 AM