Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old March 22nd, 2006, 06:02 PM
Authorized User
Join Date: Mar 2006
Location: Phoenix, AZ, USA.
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default Slow saves and views

Hey Everyone,

I have yet another question relating to my current project I'm working on. The current database has several links either to another database or text files. When saving changes to this it takes as long as 10 minutes before it's done. The same thing happens when I change from Design View to Form View on any Form that I'm working with. I had read about the SubDataSheetName field value in linked table defaults to "Auto" can cause this. Is this more than likely the case here or are there other things that I should look at first?



Old March 22nd, 2006, 09:30 PM
Friend of Wrox
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts

Hi Robert,

Two serious performance slayers in Access are SubDataSheets and the Name AutoCorrect feature. Definitely turn both off and see if that helps.

=Turn Off SubDataSheets=

Open a table in Design view. On the View menu, click Properties. Set the Subdatasheet Name property to [NONE].

=Turn off Name AutoCorrect=

Tools -> Options -> General Tab.
Turn the Track Name AutoCorrect Info option off (uncheck it). Turning this option off automatically disables the remaining options.



Similar Threads
Thread Thread Starter Forum Replies Last Post
combo box saves Number of Values JpaulH Access VBA 2 May 3rd, 2006 06:55 AM
Visual Basic Editor saves only sometimes crmpicco Excel VBA 0 May 10th, 2005 08:43 AM
converting Access 2000 views to Sql views matta Classic ASP Professional 1 January 26th, 2005 03:37 PM
saves wrong dateformat in Access Haroldd Access ASP 2 July 23rd, 2003 03:30 AM
Views SAM GORDON SQL Server 2000 5 July 19th, 2003 08:14 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.