We recently experienced system.mdw file corruption almost daily. This is very unusual as we only had backend file (xxx.mdb) or frontend file corruption in the past, but never system file. Now while the backend and fronted databases are stable, we got daily system.mdw corruption. We have noticed that once the system.mdw file goes up to around 512kb, it will not let anymore user to log in. The user who is trying to log in to the database will now get a warning dialog box "Can't recognize database system.mdw..." At this moment we will have to ask everyone to log out and do a repair and compact the system.mdw file.
The only thing special with our environment this that:
We are on Citrix with Windows 2000 with 4 pair of frontend-backend files, with each pair having a unique system.mdw file.
We don't know if by installing Office Service Release (SR-1a) and Service Pack (SP-2) is the solution. Any help would be greatly appreciated!