Subforms and speed

[GaryRW]

I've got a main form with a tab control with 10-12 pages. Most have subforms on, and most of those have one further subform.
.
The main form takes some time (about a minute) to load up now and taking its time closing for that matter. Ideally I would like to add further subforms to the tab pages but am worried about slowing the whole thing down even more.

Should the form be slowing down at this sort of number of subforms or are there ways of speeding up the loading process?

Thanks in advance for any help

 

[jgoodman00]

Check your database is compacted. This affects performance.

Also, if you are running Access 2000 or later, make sure the [Name Autocorrect] options are deselected in the [General] tab of the [Options] dialog.

I have tested forms with 30 tab control pages, with excellent performance. However, many embedded subforms are bound to impact performance (if you have 3 embedded subforms, 3 seperate recordsets need to be opened). This will be especially noticeable if you are running the db across a network. James Goodman

http://www.james-goodman.co.uk

 

[Guest_imported]

GaryRW,

Suggest you look into converting your database to an MDE format. Basically compiles the database instead of having to interpret line by line (object by object).

I have a similar problem with list boxes in a subform. Converting to MDE improved the performance a lot. I am no expert .. so do a fair bit of trialling before you do the master file.

I picked this up from the help files somewhere.

Stu

 

[jgoodman00]

Converting to an MDE file will improve performance greatly, & again the enhancement will be multiplied if it is being run across a network... James Goodman

http://www.james-goodman.co.uk

 

[GaryRW]

Thanks all.

I've tried coverting to MDE before but it just told me that it couldn't do it - with no explanation. I think I need to spend some time looking at MDE's though.

 

[jgoodman00]

Failure to convert to an mde can indicate there is an error somewhere in your code, which means it cannot be compiled (part of the procedure when you create an mde). To test for this, try manually compiling the file (Debug, Compile)... James Goodman

http://www.james-goodman.co.uk