Speed Issue on Server

[Guest]

I have form1 which opens up form2 which has subform1 on it. On a local drive
form2 comes up fairly quick, but on the server it probably takes 4 times as
long. Does anyone have any suggestions on how I can speed this up. I'm
pretty sure the slowness is due to loading subform1 which has a record source
which is made up of 2 tables... pretty simple. You would think it shouldn't
take that long to load. Is there anything I can do to improve the
performance?

Any suggestions are greatly appreciated.

Thanks,
Sarah

 

[Jeff Boyce]

Sarah

I couldn't tell from your description whether your form was on the server,
or the forms' underlying data was on the server. The standard
recommendation for architecture has the data located on your server (LAN,
not WAN) and a copy of a "front-end" .mdb file on each/every PC that needs
to use the data (the front-end is linked to the data stored in the
server-based "back-end").

With this design, the forms are all located locally, on the user's PC. If a
particular form takes a long time to load, it may be because the form is
bound to every record. A way around this is to bind the form to a single
record, or to no records, and provide a mechanism on the form for
identifying/selecting a single record, after which (in the AfterUpdate
event) the form is then loaded with the newly selected record.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff,

The forms and the underlying data are both on the server. I tried what you
said as far as putting the front-end on my local drive and left the data file
on the server. The performance is still the same.

The subform is a datasheet form which shows about 30 records at a time.
This is a requirement by the user. Is this why it is running so slow?
Anything else I can do?

Sarah

 

[Albert D.Kallal]

Check the follwing...and try each of the suggestions:

http://www.granite.ab.ca/access/performancefaq.htm

 

[Guest]

Albert thank you so much. Those suggestions worked great!