Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Mon Nov 1 09:47:51 CST 2004
Sander: What happens if you move the back end to a local machine, relink the tables? Does it open fast? Also, are you relinking the tables on open every time? Rocky Smolin Beach Access Software http://www.e-z-mrp.com ----- Original Message ----- From: "S D" <accessd667 at yahoo.com> To: <accessd at databaseadvisors.com> Sent: Monday, November 01, 2004 6:24 AM 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 >