Discussion Locked

access in local network

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
can I use access 2000 to creat a multiuser program?

2 replies

by sixfourtykilo

Access was designed to share information between users on a network. It has the ability to lock records if they are being edited, to prevent other users from over-writing that same data. More advanced features include the ability to set up security to allow access to only certain areas of the database, and the ability to track exactly who modified data without having the user have to enter their information (using their Windows logon ID).

Sharing the database is very simple. Just place it on a network share and everyone can instantly use it. If you're in an environment where there is alot of data in which lots of users are modifying, you can create a back-end to the database that prevents corruption from destroying your data.

This discussion is closed to new replies.