We use several Access 97 databases with up to 30-40 users where I work. They are all split into back and front ends, both located on our server. We have a problem with the back ends of two of our 'high traffic' databases becoming corrupt sometimes 2-3 times a day. Our network is a mix of Windows 95, 98, NT, and two Windows 2000 machines. I downloaded a program that looks at the .ldb header of a database and can tell which user has corrupted the database. 9 times out of 10, the machine that corrupts the database is one of our Windows 2000 machines. Our users on the Win2k machines say that when the database becomes corrupt, the front end usually freezes or doesn't work properly. However, the users on the 95, 98, and NT workstations can usually use the front end without any problems until they close it and try to get back in later. Does anyone know of any compatibility issues between Win2k and Access 97.
I'd appreciate any help/suggestions anyone can give me.
Thanks
Mike Rohde
rohdem@marshallengines.com
I'd appreciate any help/suggestions anyone can give me.
Thanks
Mike Rohde
rohdem@marshallengines.com