Allow multiple login to the same Access system

[lilywong]

I have a tracking access system written in access 2007. however, the system only allow one user to login to the same system at one time. the system is being locked once a user has login to the system. how do i allow multiple users to access to the same system at the same time? pls advise.

 

[rainman89]

Split your database and give each user their own front end. This will allow many connections to the same db

 

[lilywong]

if i create a shortcut on each individual user, and user login to the database by clicking the shortcut on their desktop, will this works?

 

[DCrake]

No. As mentioned you need to split the application between Data and objects. The data (tables) reside in a central shared location and the user interface (front end) has links to the tables (back end) then a copy of each front end is distributed to each person who has access to the application. This will reside on their own workstation. You then create a shortcut to point at this front end which is opened locally but sees the back end data. There are many reasons for this methodology, the main reason being corruption. There are many articles on this subject, I suggest you research this for a more detailed explanation.

David

 

[rainman89]

No. That will be the same thing.

 

[lilywong]

any thread to describe this in detail? thanks

 

[rainman89]

http://www.accessmvp.com/JConrad/accessjunkie/splitting.html