Jim Dettman
jimdettman at earthlink.net
Mon Nov 1 10:00:36 CST 2004
Couple tips here: 1. Make sure all MDB/MDE's are in the same format (JET 3.x vs 4.0) 2. *Always* keep a connection to the BE database while the FE is open. I do this by opening a hidden form bound to a table in the BE right at startup and close it when the app exits. This is critical. 3. Make sure the files are not being virus scanned at startup. 4. Turn off OPLOCKS (Opportunistic Locking) on the server. 5. Turn off sub datasheets 6. Turn off name autocorrect 7. Make sure all users have full read/write/delete priv for the directory where the MDB resides. 8. Make sure your distributing a compiled FE to clients. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of S D Sent: Monday, November 01, 2004 9:24 AM To: accessd at databaseadvisors.com Subject: [AccessD] Network issues PLEASE ADVISE Hi group, I've got a MAJOR problem. I've got an A2K application with a BE and a FE. FE is installed on the local machine and the BE is installed on the server. Using WinNT Performance has always been soso. Not fast but not very slow either. Now we've migrated everything to A2k2 with WinXP. Performance is terrible times 10!! Opening the FE takes about 20-25 minutes. Opening a linked table takes 9 minutes same goes for tables in the FE itself. However, when I open the FE and if I open a table that is stored in the FE it opens directly, no problem. When I then open a linked table => bang back to 9 minutes per table (linked or not) Is it possible that this somehow has to do with A2k2?? I know in Access 2 (that is two!!) you had to change OPENFILES parameter thingies somewhere. Does Access 2002 also have such a setting that must be tweaked?? TIA Sander --------------------------------- Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com