Hi,
I have developed a small database which tracks projects, and items within a project.
Because the database may be accessed by 3 or 4 different people, I have placed a copy of the database (with all forms and reports removed) on a network drive, and the users have local copies of the database with forms and reports intact, and linked tables pointing to the server.
The problem is, their network is terribly slow. it takes about 15 seconds to transfer 500kb. That is ok, as the whole server portion of the database is only 560k, but when the users try to use the system, pulling data across from the linked tables can take up to 2 minutes (even just small tables with minimal data in).
I don't expect to get better performance than the poor network can cope with, but it is currently running far far slower than the network can cope with.
Is there anyway I can speed up the linked tables performance in access?
Many Thanks
Alan
I have developed a small database which tracks projects, and items within a project.
Because the database may be accessed by 3 or 4 different people, I have placed a copy of the database (with all forms and reports removed) on a network drive, and the users have local copies of the database with forms and reports intact, and linked tables pointing to the server.
The problem is, their network is terribly slow. it takes about 15 seconds to transfer 500kb. That is ok, as the whole server portion of the database is only 560k, but when the users try to use the system, pulling data across from the linked tables can take up to 2 minutes (even just small tables with minimal data in).
I don't expect to get better performance than the poor network can cope with, but it is currently running far far slower than the network can cope with.
Is there anyway I can speed up the linked tables performance in access?
Many Thanks
Alan