hi Sarah,
Local will always be faster. One thing you can do to enhance performance is to use a short path. Where is the drive physically located in relation to where you are? And do you know the path of the cables?
a couple suggestions to help performance:
Use short primary and foreign keys like AutoNumber/Long Integer as opposed to text fields with big Size
Build indexes on fields that are used for searching
have an awesome day,
crystal
free code you can use in your projects
https://msaccessgurus.com/code.htm
On 7/3/2019 2:08 PM, sarahk@schemesoftware.com [MS_Access_Professionals] wrote:
I just installed a new application: MS Access 2003, split. When I run it on a network drive it is extremely slow, but when I run the exact same application on the local drive it is very fast. I had to move the front and back end to the local drive, just moving the front end did not improve the performance. its a small db , less than 3MB for now.
What could be the reason?
All help is appreciated.
Thanks??Sarah
__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar