I am currently a small business IT developer/manager and I have what is hopefully an easy question. We currently run a VB program that updates/connects and writes to an Access file as well as update with Quickbooks. Upon investigating data corruption and other issues with this program it would seem that I cannot improve the performance/speed of the program concerning the dynamic listing of the data. I have argued with the programmer that when programming in Access without using the .net or a dynamic database server system, that the program in question typically will attempt to copy over the entire or a large portion of the access file to the local machine from the server before updating any input or modification. Bear in mind the file is roughly 600mb large.
Am I right? Does access slow things down by copying the files over to the local user in a multi user environment? Is this a networking issue, a programming issue, or just the way access and VB interact?
sorry for the newbie question, and I hope it is spelled out well enough, but thanks for helping put a semi office fued to rest.
