I've just about finished converting an access 2003 database to an adp based on sql server 2000. One of the big problems remaining is that I've got a couple of forms that are taking too long to load up. I'm just looking for suggestions on how I can improve on this. One form takes 30 secs to open the other about 45 - 1 minute.

One of the forms consists of a main form based on a stored procedure that returns 1 record. I run the sproc and enter the 2 parameters and the results come back immediately.

The subform is based on a sproc as well. I run this and enter the 1 param and that too returns the values immediately.

I should mention the subform has got quite a few combo boxes that have sql as record source.

Any ideas on how I can make this load faster?

Thanks,

Peter

Peter,

I should mention the subform has got quite a few combo boxes that have sql as record source.

You can move the LookUps for the combos to the front-end.

Or, you can look for other ways that you can avoid moving an entire table
over the Net.

Wayne