MS Access support !

[Nick123]

Hi!

I want to create a database using MS Access that can be accessible by 80 users for information search purpose. At the same time at least 20 users out of 80 can make modifications. Need suggestion will that be possible in access.

The database will store in shared drive. Also want to know how to lock a record let say if user1 has access certain record for modifications than the second user can access database but not allow to modifying the record which is already under modification phase.

Appreciate any help on it.

Regards,
Nick

 

[Dennisk]

Access detects multi-user senarios automatcally but you can change the locking strategy.

Access has a system call workgroup security where you can set up group permissions etc. Normally you would create an Administrator acount , full update permissions and read-only permissions.

Finally if all 80 users logged onto an Access db then in all proballity it will grind to halt. But there are posters who may disagree. it all depends on the size of your datasets.

 

[Nick123]

Thanks

Thanks a lot.


Regards
Nick