Hello Everyone,
My company is running two separate databases, one for Rentals and one for Maintenance and Accounting. We've been successfully running these same databases for 3 years with little to no issues. Within the last 2-3 weeks, we've been experiencing significant slow downs. Sometimes it's a handful of users while sometimes it seems to be everybody in the office. On one occasion the issue seemed to be solved by replacing the ethernet cables of two of our users. However, the issues have been intermittent and returned today with all users experiencing serious lag time when retrieving data. The databases are split, with the back ends saved on our local area network and each user has their own front end saved to their desktop. The databases are compacted and repaired regularly, I have tried moving all tables for BOTH databases into new back ends and front ends. I have checked to make sure the databases open with record level locking - no locks. All forms, queries, and reports are set to no locks. I find it difficult to believe it would be a database issue when the issues seems to be across BOTH databases and began to happen at exactly the same time. Our IT guy has checked our network and isn't able to find any issues. We don't have our virus scan set up to scan our DB files, and it runs at night when no one is in the office. Any ideas what else we could look at to try to identify the problem?
My company is running two separate databases, one for Rentals and one for Maintenance and Accounting. We've been successfully running these same databases for 3 years with little to no issues. Within the last 2-3 weeks, we've been experiencing significant slow downs. Sometimes it's a handful of users while sometimes it seems to be everybody in the office. On one occasion the issue seemed to be solved by replacing the ethernet cables of two of our users. However, the issues have been intermittent and returned today with all users experiencing serious lag time when retrieving data. The databases are split, with the back ends saved on our local area network and each user has their own front end saved to their desktop. The databases are compacted and repaired regularly, I have tried moving all tables for BOTH databases into new back ends and front ends. I have checked to make sure the databases open with record level locking - no locks. All forms, queries, and reports are set to no locks. I find it difficult to believe it would be a database issue when the issues seems to be across BOTH databases and began to happen at exactly the same time. Our IT guy has checked our network and isn't able to find any issues. We don't have our virus scan set up to scan our DB files, and it runs at night when no one is in the office. Any ideas what else we could look at to try to identify the problem?