My database is split with a front end that is used by upto 200 people,* size of front end is 12mb, and each user copies this into their temp folder everytime they open the database.
The back end - I actually have 3 different back ends.* 1 that imports data from our system every night, this file is approx 300mb, my forms lookup information from this file,* 2nd file is the data that we input, this is currently 250 mb, and the 3rd is some data we archive daily, this is currently 100mb.
I have a schedule that copies all the back ends to a slave pc every 2 hours, and overnight they all compact and repair.
Backend 1 and 2 are used in the majority of forms, and are stored in different sub folders.
Backend 3 is only used by me and is not linked to any forms, but it is linked to the front end.
In total we have approx 200 people who use the database, the majority of them are based in the same building as the server, but approx 50 if them are based approx 40 mile away and this causes poor performance over the network. A form in head office can take 20 seconds to open, but at the remote sites this can turn quickly into 4 minutes.
Access is not supported by our it team, and I have no control over the network, so need to try and speed up without any internal support
I suppose my question to start with is should I have 3 back ends in different folders, should i move them sll into the same folder, or should these all be in 1 back end. I have 3 back ends as I was thinking it would be quicker to pull the smaller files over the network instead of 1 big file,
Any help appreciated
*
*
The back end - I actually have 3 different back ends.* 1 that imports data from our system every night, this file is approx 300mb, my forms lookup information from this file,* 2nd file is the data that we input, this is currently 250 mb, and the 3rd is some data we archive daily, this is currently 100mb.
I have a schedule that copies all the back ends to a slave pc every 2 hours, and overnight they all compact and repair.
Backend 1 and 2 are used in the majority of forms, and are stored in different sub folders.
Backend 3 is only used by me and is not linked to any forms, but it is linked to the front end.
In total we have approx 200 people who use the database, the majority of them are based in the same building as the server, but approx 50 if them are based approx 40 mile away and this causes poor performance over the network. A form in head office can take 20 seconds to open, but at the remote sites this can turn quickly into 4 minutes.
Access is not supported by our it team, and I have no control over the network, so need to try and speed up without any internal support
I suppose my question to start with is should I have 3 back ends in different folders, should i move them sll into the same folder, or should these all be in 1 back end. I have 3 back ends as I was thinking it would be quicker to pull the smaller files over the network instead of 1 big file,
Any help appreciated
*
*