Hey Everyone,
Over the past 6-8 months, I have been assigned the project of building a rather large database for our department. This database is split into two seperate databases, with the tables residing on a network shared drive and the menu system running locally on the machine. The problem that I am running into is as soon as we store the linked files on the network drive, the database bogs down because there the network drive is slow in general due to the amount of users accessing it all day. However, when the link tables are stored locally, or on a flash drive, the database has no performance issues at all.
I made the suggestion to get our own dedicated server to house this database to help eliminate the problem, however, the tech department says the problem is Access in general and unless I adopt a different program for my database, I will always have performance issues with multiple users. Does anyone know if this is a true statement? I currently only have about 3-5 users logged in at any one time but would like to increase the amount to about 30-40.
Quick note: The database is slow only when the linked tables are located on the network drive, even if only 1 user is logged in. Also, I have been through the performance threads on this forum and have taken all mentioned suggestions for increasing the performance of linked tables into consideration.
Thanks for the help in advance!
Jason