Hi all,
I have a split database with the back end stored on a server in another state on our network. It has to be where it is and that is all I can say about that.
The front end has several forms for data input. All open fairly quick but I have one form that has 118 fields on it plus a combo box (so I guess it is 119). This form takes anywhere from 90 seconds to 180 seconds (sometimes longer depending on network) to open and the only reason I can deduce is due to having so many fields on it.
I have tried to hide a lot of the fields that do not always need input and then call them back into visibility with checkboxes but this of course does not solve the problem.
Does anyone have any code ideas to help with this solution?
This is the same form I posted about a while back asking about hiding fields and making them visible on criteria but the database was then not a split one and this was not an issue.
In advance I have read the many sites with all of the tricks for speeding up performance up to and including the persistent connection which I have used but did not help.
I have a split database with the back end stored on a server in another state on our network. It has to be where it is and that is all I can say about that.
The front end has several forms for data input. All open fairly quick but I have one form that has 118 fields on it plus a combo box (so I guess it is 119). This form takes anywhere from 90 seconds to 180 seconds (sometimes longer depending on network) to open and the only reason I can deduce is due to having so many fields on it.
I have tried to hide a lot of the fields that do not always need input and then call them back into visibility with checkboxes but this of course does not solve the problem.
Does anyone have any code ideas to help with this solution?
This is the same form I posted about a while back asking about hiding fields and making them visible on criteria but the database was then not a split one and this was not an issue.
In advance I have read the many sites with all of the tricks for speeding up performance up to and including the persistent connection which I have used but did not help.