Connecting multiple MS Access databases in Vb 6.0 application

[judelakmal]

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.

[nico5038]

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...

Nic;o)

[NeoPa]

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.