Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / May 2007

Tip: Looking for answers? Try searching our database.

Very slow forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Rod - 23 May 2007 11:31 GMT
I have taken over looking after a database for a charity.

It works fine on the machine it was set up on, but when I move it to another
machine it slows right down. I.e it can take minutes to load a form. (the
time is spent before any of the open or load events fire)
Even in design mode saving a form can take minutes (but seconds on the
original machine).
The form is complicated but the size of the database is small, 100s of
records only, but with many tables.

Anyone seen this sort of thing before or got any clues as to what to look
for.

thanks

Rod
Scott McDaniel - 23 May 2007 14:56 GMT
>I have taken over looking after a database for a charity.
>
[quoted text clipped - 5 lines]
>The form is complicated but the size of the database is small, 100s of
>records only, but with many tables.

Are the tables linked? Or is this a fully stand-alone database (i.e. all local tables, no linked tables). Linked tables
can cause a definite slowdown over a network.

Make sure that you have no missing references on the problem machine ... open the database, open the VB editor, and see
if any are marked MISSING. Generally this causes other problems (i.e. error messaes when the database is opened) but
it's worth a try.

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
Rod - 23 May 2007 16:58 GMT
>>I have taken over looking after a database for a charity.
>>
[quoted text clipped - 20 lines]
> scott@takemeout_infotrakker.com
> www.infotrakker.com

There are linked tables, but would you expect this to slow it down when
saving in design mode.

The mystery is why it can work OK on another (slower machine).
Fred Boer - 23 May 2007 17:15 GMT
Dear Rod:

Check to ensure that Name AutoCorrect is turned off - that may fix it.
You may also find the following useful:

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

and particularly...

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

That one fixed it for me when I had this problem.

HTH
Fred Boer

>>>I have taken over looking after a database for a charity.
>>>
[quoted text clipped - 25 lines]
>
> The mystery is why it can work OK on another (slower machine).
Rod - 24 May 2007 10:28 GMT
You're the man

ta

> Dear Rod:
>
[quoted text clipped - 42 lines]
>>
>> The mystery is why it can work OK on another (slower machine).
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.