Access database and DFS
Posted on 2009-02-23
I have been tearing my hair out with this one...
I have a totally bespoked Management Information System (which I am in the process of phasing out) that is built on access.
It has many database and uses linked tables to share the info betweeen each database.
Now here is the problem... We recently decided that it would be a good idea to move the database over to a DFS strucutre (Distributed File System). We have made all of the necessary changes to the linked tables and the system works..
But when I try and edit a report the speed is absolutley appalling.. In order to move a text box, I have to click and guess where I am dropping it...!!
Any ideas, Both the File Server hosting the solution and all of the clients have the KB from M$ concerning slow access for a workstation when accessing things via DFS...