MS Access and multi user env

  • Thread starter Thread starter Leena
  • Start date Start date
L

Leena

Hi
I need to create an MS Access application that will have
many users using the data at the same time. What is the
limit on the total number of connections to the databse
and what is the limit to the number of concurrent users ?
In a network environment, how do i make th application
available to everyone on the network ? Do I put it on the
server and will everyone open a copy of the mdb file ?
If i create an application using VBA will it be integrated
with MS Access and if i need to open the application I
HAVE to open the entire mdb file ?
 
When using Access for a multi-user application you should
split the DB into a Back End (tables) and a Front End
(forms, reports, etc. w/ linked tables to the Back End).
This will give you much better performance and help avoid
locking problems with the .ldb file. The Front End
application should then be placed on each users computer
and the tables linked to the Back End on a network file
server.
 
Back
Top