A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Slow form, again



 
 
Thread Tools Display Modes
  #21  
Old February 25th, 2010, 09:23 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Slow form, again

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/For...esign/201002/1

  #22  
Old February 26th, 2010, 03:57 PM posted to microsoft.public.access.tablesdbdesign
jenniferspnc
external usenet poster
 
Posts: 65
Default Slow form, again

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/For...esign/201002/1

.

  #23  
Old February 26th, 2010, 04:35 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Slow form, again

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" wrote in message
...
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/For...esign/201002/1

.



  #24  
Old February 26th, 2010, 05:52 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Slow form, again

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



"jenniferspnc" wrote in message
...
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/For...esign/201002/1

.



  #25  
Old February 26th, 2010, 06:18 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default Slow form, again

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" wrote in message
...
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



"jenniferspnc" wrote in message
...
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/For...esign/201002/1

.




  #26  
Old February 26th, 2010, 06:46 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Slow form, again

Knock it off, Steve. If you have an idea what to do, say it. If you don't,
having the database in front of you will not help. As you should know by
now, these groups are for free support.

Steve wrote:
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


Yes, it is a LAN (not wirless), and excuse my earlier ignorance.

[quoted text clipped - 26 lines]

.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201002/1

  #27  
Old February 26th, 2010, 07:41 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Slow form, again

Jennifer,

It's time to get your problem fixed and move on. Let me try.

Steve



"Steve" wrote in message
...
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



"jenniferspnc" wrote in message
...
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/For...esign/201002/1

.





  #28  
Old February 26th, 2010, 07:53 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Slow form, again

Jennifer

As others have pointed out, these newsgroups are "staffed" by (mostly)
volunteers, and are intended to offer FREE assistance. In fact, the Code of
Conduct specifically mentions that solicitation is not permitted.

Before hiring someone who uses these newsgroups to solicit paid work, you
may want to ask yourself if you want to do business with someone who ignores
the rules ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"jenniferspnc" wrote in message
...
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/For...esign/201002/1

.



  #29  
Old February 26th, 2010, 09:58 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Slow form, again

"Steve" wrote in message
...
Jennifer,

It's time to get your problem fixed and move on. Let me try.

Steve



No, it is time you stopped harrassing people for work.


Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP


  #30  
Old February 26th, 2010, 09:59 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Slow form, again

"Steve" wrote in message
...
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



Move on stevie. No one wants your quesionable services


Stevie is our own personal pet troll who is the only one who does not
understand the concept of FREE peer to peer support!
He offers questionable results at unreasonable prices.

These newsgroups are provided by Microsoft for FREE peer to peer support.
There are many highly qualified individuals who gladly help for free. Stevie
is not one of them, but he is the only one who just does not get the idea of
"FREE" support. He offers questionable results at unreasonable prices. If he
was any good, the "thousands" of people he claims to have helped would be
flooding him with work, but there appears to be a continuous drought and he
needs to constantly grovel for work.

Please do not feed the trolls.

John... Visio MVP


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.