Arthur Fuller
artful at rogers.com
Sat Mar 1 07:58:00 CST 2003
Another approach that does not require moving to SQL and yet delivers all the speed of a one-MDB solution is to use Replication Manager and place a local replica on each PC using the app. Then on the server you place the Replication manager itself and synchronize the local replicas with the "server" replica every 5 minutes or every hour or whatever interval is appropriate to your app. -----Original Message----- From: accessd-admin at databaseadvisors.com [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark L. Breen Sent: March 1, 2003 5:26 AM To: accessd at databaseadvisors.com Subject: [AccessD] Access & Windows 2000 Performance issues with linked tables Hello All, I was asked recently to move a database that I created three years ago from a Win NT 4.0 Server server to a new Windows 2000 Server server. The database application that I developed is built on a FE, a BE and a MDA file and also a .mdw file. When the backend is on the NT server, performance is fine, but when I move it to the new Windows 2000 server ( a super duper server with loads of disk / ram / processor ), it grinds to a halt. To make a long story short, it appears that Microsoft have introduced something to the Win2K and WinXP OS's that cause linked tables to perform very slowly. There is an article in the KB about this. Their suggestion (as opposed to the fix) is instead of talking to the properties of the linked tables, to programatically open the backend and talk directly to the properties of the source tables. In my case, I would have to re-write the entire application and it is not ecomomical to do so, a better alternative to that would be simply to rebuild the app in SQL and use ADO. However, I had another idea which was to bring the BE back into the FE and leave it as one .mdb file. When I tried that it solved my problem. The purpose of this email is to share the information with you guys and ask if you have experienced this also. Incidently, the 'normal' operations such as reading data, querying etc, was never impaired, it was only when talking to linked tables, If you wish to demonstrate this for yourself, create a db with one table and with about eight fields or so. Save the db as Somename_BE.mdb on a > = Win 2k machine, it can be Pro or Server. Then create another db and link to Somename_BE.mdb. Finally, let the form wizard create a new form and pull all the fields in. The form creatation should talk you about ten seconds or so. If you do the same thing on a Win NT Server, it happens in one second. I do not know if this will help anyone, but hopefully it might. Best Regards Mark L. Breen Solution Providers Ltd Ireland _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com