By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,256 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Connecting multiple MS Access databases in Vb 6.0 application

P: 3
I have an application written in vb 6.0 application. It connects multiple MS Access databases sometimes. I would like to know is will this effects the performance of the application.
Feb 28 '07 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,072
Depends on the type of connection and the size of the tables.
Best to do some testing with timestamps to see the effect of the different types (when applicable) and to use e.g. MS SQL or MySQL as an alternative.
Too many things (network and network drivers) that can influence this to tell you from a distance...

Feb 28 '07 #2

Expert Mod 15k+
P: 31,299
There are many things which will affect the performance of your application but I know a number of people who prefer to use VB as a front end and I'm fairly sure that that, in itself, won't cause you many performance delays.
The idea of using linked databases, rather than everything (data, objects and code) being stored together locally, is highly recommended and I would doubt equally, that this concept will cause you noticeable performance problems.
Mar 1 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.