Slow form, again
in [Tables]
|
Prev: How do I change the order that my records appear in in Forms
Next: Set Controls Default Value from another Control
From: BruceM via AccessMonster.com on 25 Feb 2010 15:23 I didn't see this in the performance FAQ link (although I could have missed it), and I don't think you mentioned it: when the database BE is on the LAN (not wireless, I hope), open a form bound to a BE table (or a query that uses a BE table). Minimize it if you like, but leave it open. Now try to run the problem query, or load the form. Any change? jenniferspnc wrote: >The back-end is a .accdb (using Office 2007). > >Does that help?? Sorry IT is not my area :( > >> 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.) >[quoted text clipped - 94 lines] >> >> . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1
From: jenniferspnc on 26 Feb 2010 09:57 Yes, it is a LAN (not wirless), and excuse my earlier ignorance. I do have a form that is bound to a dummy table in the BE to keep a persistent connection (it opens with the welcome screen). It's truly frustrating because I want to believe that it is the network and not my database design, although I am not an expert on databases (read and learn is how I get by). "BruceM via AccessMonster.com" wrote: > I didn't see this in the performance FAQ link (although I could have missed > it), and I don't think you mentioned it: when the database BE is on the LAN > (not wireless, I hope), open a form bound to a BE table (or a query that uses > a BE table). Minimize it if you like, but leave it open. Now try to run the > problem query, or load the form. Any change? > > jenniferspnc wrote: > >The back-end is a .accdb (using Office 2007). > > > >Does that help?? Sorry IT is not my area :( > > > >> 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.) > >[quoted text clipped - 94 lines] > >> > >> . > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1 > > . >
From: Gina Whipp on 26 Feb 2010 10:35 Jenniferspnc, And it very well could be the network but we have to get thru insuring it is not the database first! So far I have seen nothing that indicates it's the database. How many controls (fields are on each form/subform and do you have any calaculated fields on the form/subforms? -- 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" <jenniferspnc(a)discussions.microsoft.com> wrote in message news:2FB2BA22-E845-48F0-94C6-4B40D7376675(a)microsoft.com... Yes, it is a LAN (not wirless), and excuse my earlier ignorance. I do have a form that is bound to a dummy table in the BE to keep a persistent connection (it opens with the welcome screen). It's truly frustrating because I want to believe that it is the network and not my database design, although I am not an expert on databases (read and learn is how I get by). "BruceM via AccessMonster.com" wrote: > I didn't see this in the performance FAQ link (although I could have > missed > it), and I don't think you mentioned it: when the database BE is on the > LAN > (not wireless, I hope), open a form bound to a BE table (or a query that > uses > a BE table). Minimize it if you like, but leave it open. Now try to run > the > problem query, or load the form. Any change? > > jenniferspnc wrote: > >The back-end is a .accdb (using Office 2007). > > > >Does that help?? Sorry IT is not my area :( > > > >> 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.) > >[quoted text clipped - 94 lines] > >> > >> . > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1 > > . >
From: Steve on 26 Feb 2010 11:52 Jennifer, You're getting nowhere and spending a lot of time doing it. Look at my earlier response to you. My offer is still open to try and help you. Steve santus(a)penn.com "jenniferspnc" <jenniferspnc(a)discussions.microsoft.com> wrote in message news:2FB2BA22-E845-48F0-94C6-4B40D7376675(a)microsoft.com... > Yes, it is a LAN (not wirless), and excuse my earlier ignorance. > > I do have a form that is bound to a dummy table in the BE to keep a > persistent connection (it opens with the welcome screen). > > It's truly frustrating because I want to believe that it is the network > and > not my database design, although I am not an expert on databases (read and > learn is how I get by). > > > "BruceM via AccessMonster.com" wrote: > >> I didn't see this in the performance FAQ link (although I could have >> missed >> it), and I don't think you mentioned it: when the database BE is on the >> LAN >> (not wireless, I hope), open a form bound to a BE table (or a query that >> uses >> a BE table). Minimize it if you like, but leave it open. Now try to run >> the >> problem query, or load the form. Any change? >> >> jenniferspnc wrote: >> >The back-end is a .accdb (using Office 2007). >> > >> >Does that help?? Sorry IT is not my area :( >> > >> >> 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.) >> >[quoted text clipped - 94 lines] >> >> >> >> . >> >> -- >> Message posted via AccessMonster.com >> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1 >> >> . >>
From: Gina Whipp on 26 Feb 2010 12:18
Steve, She is getting *somewhere* (and for FREE)... depending on her last set of answers it appears as if it is the network not the database, so nothing for you to do as that would be her Company's IT department. -- 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 "Steve" <notmyemail(a)address.com> wrote in message news:uXV5bQwtKHA.5940(a)TK2MSFTNGP02.phx.gbl... Jennifer, You're getting nowhere and spending a lot of time doing it. Look at my earlier response to you. My offer is still open to try and help you. Steve santus(a)penn.com "jenniferspnc" <jenniferspnc(a)discussions.microsoft.com> wrote in message news:2FB2BA22-E845-48F0-94C6-4B40D7376675(a)microsoft.com... > Yes, it is a LAN (not wirless), and excuse my earlier ignorance. > > I do have a form that is bound to a dummy table in the BE to keep a > persistent connection (it opens with the welcome screen). > > It's truly frustrating because I want to believe that it is the network > and > not my database design, although I am not an expert on databases (read and > learn is how I get by). > > > "BruceM via AccessMonster.com" wrote: > >> I didn't see this in the performance FAQ link (although I could have >> missed >> it), and I don't think you mentioned it: when the database BE is on the >> LAN >> (not wireless, I hope), open a form bound to a BE table (or a query that >> uses >> a BE table). Minimize it if you like, but leave it open. Now try to run >> the >> problem query, or load the form. Any change? >> >> jenniferspnc wrote: >> >The back-end is a .accdb (using Office 2007). >> > >> >Does that help?? Sorry IT is not my area :( >> > >> >> 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.) >> >[quoted text clipped - 94 lines] >> >> >> >> . >> >> -- >> Message posted via AccessMonster.com >> http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201002/1 >> >> . >> |