Performance of Access when linking to another tables?

longson

New member
Local time
Today, 11:14
Joined
Oct 30, 2006
Messages
5
My situation is as follow

I have an Access datebase, where main tables are built and saved.

Also, I have 2 Access modules, which access informations in main tables in an Access datebase (I used Linking to table) and process information in query.

Questions: Linking to tables in another datebases will make perfomance of the module worse ? If the answer is Yes, then in which scale ?
 
If the database containing the main tables is on the same computer as the modules then it shouldn't make any difference.
If they are on another computer on the same site then it might make a bit of difference but probably not.
If they are on a computer at another site then you probably will get problems and I wouldn't do it at all because you can get corruption of the data in all the databases.
 

Users who are viewing this thread

Back
Top Bottom