Access 2007 SLOW in design view

#11

1. Hm, my printer is local but often unattached. I'll try plugging it
in and/or switching to "Adobe PDF" as my default printer.

2. I've already turned off auto-correct and that doesn't seem to have
worked. Shame to lose that feature, though it seems buggy to me
anyway. When I had it turned on, I changed the name of a query and it
very nicely changed all references to that query throughout the
database. But then when I tried to run a query from VBA I started
getting parameter messages looking for the old query name.

3. You're right, I had some linked tables. Wasn't using them but they
were still in the navigation pane. I've removed them now. So far so
good, but time will tell.

Thanks for the help.

On Apr 23, 6:26*am, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:

Quote:

"septimus" *wrote in message

news:4a4e3cfd-84ae-4200-8e16-8496344541c6 (AT) q30g2000vbs (DOT) googlegroups.com...

Ah, thanks AG. I do have SP2.
So what else could be causing this?

OK assuming this is not a split database, then the next couple of things to
check are if you're using an unattached or network printer?
Access constantly queries the printer for information about control layout
for both forms and reports. So if a printer is offline or not attached, or
is a network printer, this can be a source of delays .

In fact as a general Rule I now own set my default printer to a local
default PDF printer to prevent the above problem.

Another option to turn off is track name auto correct, as this can over time
be a source of delays during development - so I would disabled this feature
also.

And while your database may not be split, it's possible that you have
several table links in the table view that are network based or linked to
external data sources. Thus again this has been known to be a source of
delays during development.

If the above idea does not fix this, then work you way though the list here:

http://www.granite.ab.ca/access/performancefaq.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kal... (AT) msn (DOT) com

#12

On Apr 23, 2:19*pm, septimus <ovengra... (AT) yahoo (DOT) com> wrote:

Quote:

1. Hm, my printer is local but often unattached. I'll try plugging it
in and/or switching to "Adobe PDF" as my default printer.

2. I've already turned off auto-correct and that doesn't seem to have
worked. Shame to lose that feature, though it seems buggy to me
anyway. When I had it turned on, I changed the name of a query and it
very nicely changed all references to that query throughout the
database. But then when I tried to run a query from VBA I started
getting parameter messages looking for the old query name.

3. You're right, I had some linked tables. Wasn't using them but they
were still in the navigation pane. I've removed them now. So far so
good, but time will tell.

Thanks for the help.

On Apr 23, 6:26*am, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com
wrote:

"septimus" *wrote in message

news:4a4e3cfd-84ae-4200-8e16-8496344541c6 (AT) q30g2000vbs (DOT) googlegroups.com....

Ah, thanks AG. I do have SP2.
So what else could be causing this?

OK assuming this is not a split database, then the next couple of things to
check are if you're using an unattached or network printer?
Access constantly queries the printer for information about control layout
for both forms and reports. So if a printer is offline or not attached,or
is a network printer, this can be a source of delays .

In fact as a general Rule I now own set my default printer to a local
default PDF printer to prevent the above problem.

Another option to turn off is track name auto correct, as this can overtime
be a source of delays during development - so I would disabled this feature
also.

And while your database may not be split, it's possible that you have
several table links in the table view that are network based or linked to
external data sources. Thus again this has been known to be a source of
delays during development.

If the above idea does not fix this, then work you way though the list here:

http://www.granite.ab.ca/access/performancefaq.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kal... (AT) msn (DOT) com

Update: the performance problem seems to have disappeared. I have not
always had my printer connected or set my printer to PDF, so I think
the linked tables were the culprit. No trouble since I removed them.
Thanks again to all.

#13

I was able to make the issue go away when I removed the recordsource
from my form/report. Reports were insanely slow but then moved at a
speed I would expect once the recordsource was removed.

Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access 2007 SLOW in design view

comp.databases.ms-access comp.databases.ms-access

Re: Access 2007 SLOW in design view - 04-23-2011 , 02:19 PM

Re: Access 2007 SLOW in design view - 04-26-2011 , 02:22 PM

Re: Access 2007 SLOW in design view - 05-06-2011 , 10:36 PM