Speed problem... need diagnostic help

[solun]

Access 2000 on Win2KPro

Backend lives on nice server, contains 23 tables with 3 to 600 records each (2100 kb).

Front end lives on individual users' machines. The front end has 20-odd queries, 20-odd forms and three reports. Granted, the forms are very complex with min. 3 subforms each.

For two days of every month, the users go out to field offices and communicate with the server via a 100mbsp (max) network connection.

Until recently opening one form took about a minute in the field. It now takes 20 in the field!!!! Compact & repair reduces the database size from 21,000 kb to 1,800 kb, but when the database is used again, it quickly shoots back up.

Ideas on how to diagnose this? fix it?

Thank you, oh great experts!

 

[MajP]

Not sure if this will help, but read this post and the links for some good information on speeding up a A2k FE/BE application. thread702-1127475

 

[TheAceMan1]

How are ya solun . . .

Can't say much about the site the users link too, but you may wanna consider [blue]FTP[/blue] . . . its always worked well for me! . . . a little password and its the [blue]equavilent of an direct download[/blue] (no other traffic considered!) . . . Always beats site downloads (

http://www.)

in speed!

See Ya! . . . . . .