I have a Customer Service database with over 70,000 customers in it. I
have Normalized the whole thing. When a Customer Calls in, a Customer
Service Representative looks up their record, and it contains all the
customer's information. In the last few weeks, it has been taking
longer and longer for the records to be found. I have index all the
common search fields. They currently open a Form that has the
Customer Accounts as a main form, and all of their "Notes" as a sub
form. We have at most 4 people in the database at 1 time. How can I
increase the speed in which the accounts are found? We are using
Access 2003 with all the latest patches installed. The database is
stored on our Windows 2003 Small Business server.
Thanks for your help.
have Normalized the whole thing. When a Customer Calls in, a Customer
Service Representative looks up their record, and it contains all the
customer's information. In the last few weeks, it has been taking
longer and longer for the records to be found. I have index all the
common search fields. They currently open a Form that has the
Customer Accounts as a main form, and all of their "Notes" as a sub
form. We have at most 4 people in the database at 1 time. How can I
increase the speed in which the accounts are found? We are using
Access 2003 with all the latest patches installed. The database is
stored on our Windows 2003 Small Business server.
Thanks for your help.