Access Editions made by only creator/password

[coffeeman]

Our access database at work is connected to a network. When I open it (before anyone else) I can make additions, save changes, etc. As soon as anyone else opens the database, I no longer have the rights to make changes or save edits. Is there a way to prevent getting "bumped off" or exclusively letting certain people able to make editions and others not?

Thanks

 

[MarkK]

Whereas when mulitple users are connected to a database,
1) you can edit data in tables,
2) you cannot edit database objects--like forms and reports,
therefore it is very common to implement a solution that is called a 'Front-End/Back-End Split.' In this scenario you have a single file, the Back-End, that only has tables and queries, which functions as your data source and repository. In addition you have mutiple Front-Ends, which provide your user interface and business logic. The Front-Ends connect to the Back-End over your intranet.
In this scenario you and your users each have exclusive access to their copy of the FrontEnd, which can be edited at any time and you can distribute new versions, upgrades, or have completely different versions for different departments etc...