[AccessD] Network issues PLEASE ADVISE

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
> 




More information about the AccessD mailing list