[Don Sabo]

I have a problem with an Access 2002 database that I wrote. The problem is that I have 5 users that want read/write capabilites while there are 20 users who need read only capabilites and the ability to view reports. I do not want to use Access Security if I can avoid it at all costs. I first had my network engineer map a new drive where the file is stored and the 5 people had read/write privileges. The group of 20 had read only priviliges and if one of the 5 users were on, they got an message that the database was locked. I then tried to split the database into a front end and a back end according to article 304932 from Microsoft support. I also tried to copy the tables using a macro when the user was logging off, but I could not because I have joins with 3 tables. I also tried opening the file as Read only, but I know the users will not remember to do this every time they log on. Does anyone have any suggestions? If your suggestion is too complicated send me a PM and I will call you to discuss it. Thank you.