I need some guidance as I was given a task to support a 2002 Access database which was designed for a single user, but I want to expand it's usage to be multi-user. My requirement is to have two or three users have write access and up to 5 users read-only. I tried to configure using the Access Security features but it does not seem to be up to what I need (unless I'm not doing something correctly). What are my options? I'm not familiar with features of the latest Access versions, nor with MS SQL Server. My desire is to utilize the existing GUI as much as possible. Perhaps using web base interfaces for the read-only users if that would cut down on licensing costs. This is for a church so funds are tight. TIA
I have a starting article here that gives you some idea for multiuser: basically the first concert you have to learn is to split the database. http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com
