Saphirah
Active member
- Local time
- Today, 11:04
- Joined
- Apr 5, 2020
- Messages
- 163
Hey everyone,
currently i am running a Frontend/Backend Split, networked Access database.
The backend lays on a seperate computer and we are using Shared Windows folder to connect the other PC's to the backend.
(If it helps, the command we use to connect to the server is simply "net use T: \\ServerPCName\Folder")
There are around 5 active users on the database. While the database runs quite fast on a local hosted environment, it is significantly slower on the network.
To improve the speed i did various research.
So recently i did read online that you should disable OpLocks on your Server/FileHost PC when using Access Databases in a multi user environment.
This can dramatically improve the performance using the database over a network.
But most of these pages/articles are more than 5 years old, an i can not seem to find any new information on this issue.
Will disabling OpLocks improve my Database Network speed? Is it recommended?
Thank you for your help.
currently i am running a Frontend/Backend Split, networked Access database.
The backend lays on a seperate computer and we are using Shared Windows folder to connect the other PC's to the backend.
(If it helps, the command we use to connect to the server is simply "net use T: \\ServerPCName\Folder")
There are around 5 active users on the database. While the database runs quite fast on a local hosted environment, it is significantly slower on the network.
To improve the speed i did various research.
So recently i did read online that you should disable OpLocks on your Server/FileHost PC when using Access Databases in a multi user environment.
This can dramatically improve the performance using the database over a network.
But most of these pages/articles are more than 5 years old, an i can not seem to find any new information on this issue.
Will disabling OpLocks improve my Database Network speed? Is it recommended?
Thank you for your help.