Split Database Performance Still Slow 1

[davejackson]

Hi,

I have a 3Mb database that at the moment is mostly forms, queries etc. It was very slow when I run it off the network so I decided to split it and put the back end on the server and front end on PC.

However, the speed has not improved at all and forms and queries are still taking a long time to load. I am guessing this is because I have so many combo boxes on the forms created over tables. Is this right or is there a way I can improve performance?

Any help would be much appreciated.

Thanks, Dave

 

[tlbroadbent]

Check the following links.

http://www.vb123.com/toolshed/01_access/combos.htm

http://msdn.microsoft.com/library/en-us/office97/html/designingformsreportsforspeed.asp

http://msdn.microsoft.com/library/en-us/bapp2000/html/acbachap07.asp

Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)

http://www.saltlake2002.com