S
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!
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!