Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When the frontend of a MS Access db queries a MS Access backend on another machine over the network, does it pull in the whole table/database/file, or does it have some way of extracting just what it needs from the backend, thereby lessening network load.

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

The Access Database engine will only will read what it needs. However, this might mean more data is transferred across the network than you might think.

For example, if the table is indexed so that a full data scan is not needed to find your record, then it will read the index first, then only those records to satisfy the query results. Minimal data is moved across the network.

However, if you only return one row from a large table where there is no index, then the full table will be transferred across the network. This is because the query process is running on the client machine, and it needs to read all the data to do a table scan.

Thus, if you are creating an access app using this method, make sure your tables are appropriately indexed.

share|improve this answer
add comment

It's hard to answer exactly. Do you mean opening the database over a network?

I'm assuming you mean the frontend and backend are in a single MDB file.

When a query is performed (depending on the query), it will only grab the data it needs. This is true for most databases. However when the file is opened, the database integrity is checked.

For more information on the JET database backend, go here: http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine

share|improve this answer
    
No, I mean the database is split, with the frontend and backend on different machines on the network. I'm trying to determine if a SQL query in Access pulls all the tables back and then gets it's specific data from them, or if it is somehow able to pull specific data from the backend, even though there is no server process running on that machine. –  Lance Roberts Sep 24 '09 at 0:02
    
edited this into my question also –  Lance Roberts Sep 24 '09 at 0:03
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.