OK. I created this great database for the company I am working for, and now it is time to move the damn thing on to the server. The IT guy here, who is 57 and used to working on IBMs from the 80's, moved it as an accessible(no pun intended) file on the server.
Here is the problem and what my boss wants done. When you try to make a correction to the file, and someone else has it open, then the file correction will not save and automatically update the saved database. Every other person has to close the database if someone wants to make a change/addition. How do I get aroud this? Load it up on our SQL server?
Also, my boss wants to apply certain restrictions to some computers. She wants some computers to only be able to view the data and not able to change anything. She also wants others to have a password encription to changing the files. Thanks in advance to anyone that wants to help me!!!!!!