Database Discussion - Access Performance

Print Page | Close Window

Access Performance

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=6041
Printed Date: 30 March 2026 at 7:27am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Access Performance

Posted By: JohnnySlotCar
Subject: Access Performance
Date Posted: 29 September 2003 at 9:49am

Hi - I was wondering if anyone would like to offer an opinion on this...

Is it more efficient to keep multiple applications in separate Access databases, or is it better to combine tables of different applications into a single database file?

Johnny

Replies:

Posted By: dpyers
Date Posted: 01 October 2003 at 10:38am

The weasel answer is... it depends.

Server configuration, connection type, and application usage have a lot to do with it, but in general, separate access db's seem to perform better for me.

Although, if a single db was faster, I probably wouldn't go for it anyway. Application maintenance, development, and trouble shooting is easier with separate db's. Not to mention that if my one db goes south, all my apps would be dead.

-------------

Lead me not into temptation... I know the short cut, follow me.