Can anyone give me advice on where to look for possible causes of repeated database corruption?
Have been experiencing problems with database corruption in a system under development. In last few months, this Access 97 database has gone sour three times, usually fist indicated by failure to recognize the basic NZ function and string functions like Left(), Mid(), Trim(), etc.
Creating new db and importing objects from bad db then re-compiling all code takes care of the problem for a long while. However, it's happened again this morning after at least a month of working fine.
The work is being done on four different PCs with different operating systems (Win 98, XP Professional, XP Home). All those PCs have the same version of Office 97, Service Pack 2.
I worked on the db at home last night (XP Home edition) then copied the changes over VPN back to the office. Co-worker this morning (using Win 98) started getting the "Unrecognized Function NZ" and similar error messages all over the place. I frequently work from home at night and copy the changes without anyone at office (98 or XP Pro) having problems.
Any ideas where I should start looking for possible causes?
Have been experiencing problems with database corruption in a system under development. In last few months, this Access 97 database has gone sour three times, usually fist indicated by failure to recognize the basic NZ function and string functions like Left(), Mid(), Trim(), etc.
Creating new db and importing objects from bad db then re-compiling all code takes care of the problem for a long while. However, it's happened again this morning after at least a month of working fine.
The work is being done on four different PCs with different operating systems (Win 98, XP Professional, XP Home). All those PCs have the same version of Office 97, Service Pack 2.
I worked on the db at home last night (XP Home edition) then copied the changes over VPN back to the office. Co-worker this morning (using Win 98) started getting the "Unrecognized Function NZ" and similar error messages all over the place. I frequently work from home at night and copy the changes without anyone at office (98 or XP Pro) having problems.
Any ideas where I should start looking for possible causes?