View Single Post
  #20  
Old February 25th, 2010, 08:50 PM posted to microsoft.public.access.tablesdbdesign
jenniferspnc
external usenet poster
 
Posts: 65
Default Slow form, again

The back-end is a .accdb (using Office 2007).

Does that help?? Sorry IT is not my area

"Gina Whipp" wrote:

Exactly what kind of network? (I am assuming the back end is an MDB, so
don't even concern yourself with Oracle or SQL Server.)

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"jenniferspnc" wrote in message
...
Yes, when I put the BE on my desktop it will open the form in about 3
seconds.

So perhaps it's all network related? I'm not too sure about it being SQL or
Oracle...not my area of knowledge. What do you suggest and how do I go
about
doing it?

Thanks.

"DrGUI" wrote:

Jennifer:

One thing you can try is to make a copy of the BackEnd onto your local
machine and see if that speeds things up. If it does then you know that it
is
the network that is slowing you down.

Are you running SQL Server or Oracle on the BackEnd? I had a similar
problem
on a project that had Oracle on the BE and it was terrible slow. I
converted
all my Access SQL to pass-through SQL and the it sped up the application
tremendously. The form load went from approximately 1-2 minutes down to a
few
seconds.

HTH

"jenniferspnc" wrote:

Okay I'm back again, with the same problem, and at a loss. This is my
2nd
database, and same brick wall! The loading of my form takes upwards of
40
seconds to load. I've gone through steps offered at previous posts
(http://www.granite.ab.ca/access/performancefaq.htm).

I even downloaded a template database (sales pipeline) from Microsoft
and
once split it slowed down dramatically as well...takes a solid minute to
load
their form. Could that suggest that my database design is solely not
the
problem and perhaps the network doesn't help?

Details of my database: My form pulls off a query (query takes about 10
seconds for 20 records), SQL is
SELECT Opportunity.Opportunity_ID, Opportunity.Date_Today,
Opportunity.Business_Segement, Opportunity.Source,
Opportunity.[Opportunity
Details], Opportunity.Status, Opportunity.Opportunity_Value,
Opportunity.GP,
Opportunity.Timeframe_Months, Opportunity.Client_ID,
Opportunity.Approval_ID,
Opportunity.Client_Type, Opportunity.AM_ID, Opportunity.[Additional
Notes]
FROM Opportunity;

I have 3 subforms but those seem to load fairly quickly when run
individually (3-5 seconds).


I've read, "Delete the SQL from the RecordSource and RowSource
properties of
the form, subforms, comboboxes and listboxes. Now in the Form_Load event
load
the appropriate SQL." I have three combo boxes, details to follow
below.
This may be the important piece I am missing only because I am confused
on
how to go about. If this is the culprit of my design could someone
please
help me with what the appropriate SQL that should be loaded on the Event
page?

Combo Box Details:
Client: Control Source Client_ID/Row Source Client_Name/Row Source Type
Table/Query

Manager: Control Source AM_ID/Row Source SELECT [Account_Managers
Query].[AM_ID], [Account_Managers Query].[Account_Manager_Name] FROM
[Account_Managers Query] ORDER BY [Account_Manager_Name];/Row Source
Type
Table/Query

Segment: Control Source Business_Segment/Row Source
"Corp";"Mid";"Other"/Row Source Type Value List

Please help. I hear grunts when people have to enter data into this
database.

Thanks!



.