Performance Problem

[Sharkbyte]

I am in the process of moving a db from one development machine to another.
The db operates as a front-end for a SQL Server db.

When I went to test the application I experienced serious performance
problems. I have several forms that are taking up to 10 seconds to populate
data, where originally they required less than 1 second.

In tracing the problem out it seems that it is occurring when I am
populating fields in one form with data from another.

Example: [forms]![Form1]![text1] = [forms]![subfrmForm1]![text1]

DLOOKUP also seems to be affected.

As a test, I built a quick pair of forms using DLOOKUP to populate 5 fields,
and everything performed as expected. So I'm thining this may be isolated to
the imported file and not all db work. But I don't want to have to rebuild
the entire db, for obvious reasons. I would say my next step is to build a
fresh db file, and import the forms, to see if that clears it up.

Does anyone have any ideas about this? I've never seen something like this,
before, and any other ideas are greatly appreciated!

 

[Bob Larson]

I've heard that if you open a hidden bound form bound to a linked table, it
will keep the connection open instead of autoclosing. You can try that
instead. Also, while it may still resolve, you should use the correct code
for referring to subforms:
Forms!Form1.Text1 =
Forms!YourFormWithSubform.YourSubformContainer.Form.Text1

See here for more about subforms and what the .Form. has to do with things:

http://www.btabdevelopment.com/main...rhowtoreferencesubforms/tabid/76/Default.aspx

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

Free Access Tutorials and Resources: http://www.btabdevelopment.com