10 second lag opening form -
11-09-2010
, 06:31 AM
I am a novice Access user using Access 2003. I have built a database
and I am currently having a issue with one of my forms. When I select
a CmdButton on my Start Page it takes 10 seconds for the form to
open. The form trying to be opened has 3 subforms that are populated
from Queries. Each field that is being sorted in the Queries is set
to be indexed in their respective table field. The rest of the
Database seems to be working well and seems to respond in an
appropriate time. Currently this database only has about 10 records
for testing. Any help is appreciated. Also the file database file
name is less than 8 characters and is in the top level of the
directory.
Thanks for any and all help. |