(Guest blogger Juan Soto is an access MVP and founder of IT impact, Inc.) (Read more about Juan in our Q & A with him.)
We were all there. Start Access and loads your preferred access app only to see, to drag it like molasses in winter. Try these five tips to speed up the database:
Make sure have all your tables primary keyRunning a table without a primary key is like running a four-cylinder engine with only two active piston. Open to each table in Design view, and make sure that everyone has a primary key. Extra points: primary key with only one field to your limit, to stay away from interdisciplinary implementations use. Can paying not use to the individual field? Then add an AutoNumber field and make it the primary key.
Find over and over again on the same search box? Time, add a secondary index! For example, the secondary index on OrderDate is used heavily in a sequence database. Go ahead and add it and that you need more of them. (Don't overdo it by adding secondary indexes for all the fields either).
If you split your Access database in a network with other people and even it you are still divided, for a real treat. Use the Access Database Splitter and split, the bad guys already. Additional task: Let the data in the network file and copy the front end on the user's desktop and you'll speed to increase.
Our favorite tool and I hope it will also you! Using compact and repair at least once in the month-it is just good housekeeping.
When your application starts, must you show really any order since the dawn of time? Okay, if you the owner and like the bottom line to see $, then Yes, but for everyone else, consider what data download, where during your CA forms to get rid of, the open everything and load you instead forms with a "where" clause only the data displayed, you need.
(Want your access skills rev?) Then Juan connect on Friday at 8 am the central standard time for a live Webcast: "access Kung-Fu: Mastering access session." (More details find out and register here.)
No comments:
Post a Comment