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

.