Microsoft Access 2003 on Network

[ishfady]

Hi

I just like to know how Access 2003 database work on network.

When user access data base on server.
Does whole database get loaded to client pc.

Does Database data get change instanly.

I would appreciate your advice.


Many Thank

 

[BNPMike]

Access can use many data sources but I guess you mean an Access application using the default Jet database.

When a client performs a select statement, Access will fetch whatever pages it needs from the shared database to firstly work out where the required data is and then to retrieve the actual data pages. If you ask for one customer in a database of 2 million you might therefore pull back a few pages or the whole 2 million rows depending the the nature of the query. If you are concerned about large amounts of data on your network (i) consult a specialist who can anticipate how Jet will perform a qery, (ii) write very simple queries on large tables. Access may not be able to optimise complex queries, (iii) consider using MSDE (MS SQL Server) instead. It is better for shared databases although not so easy to use as Jet.

The data is updated in real time. Other users will see your data locked as you update it and will see your changes as soon as you have completed them