5 replies
by dklippert
This is a common use of Access. The records can be protected, or users can be allowed to make changes.
Most of the "3 inch thick" books have information on this. I like Que books.
There is a very good description of the process in (of all places) the help file.
Use the word "multiuser" as the search word. One particularly good topic is "Share an Access database on a network.
by hettymedia
by glenda gable
I agree.. the QUE books are great. Technically you dont need to ADD anything to make it a multi-user database. Access automates a number of activites. Of course the database would have to be on a network or shared drive for other users to access it.
Setting up a security file is fairly easy using the Security Wizard. Having a book to step you through it does help, but you can also use www.microsoft.com/ (Go under Support>> Knowledge Base). I use this as a helpful tool LOTS!
The easiest way to use the security file is to put an icon on everyone's desktop pointing to the database and security file. If you choose this option just email me and I will help out with what you type in the "Target" line of the Properties for the icon.
If you have a smarter user, they could still get into the database without the security, so this isnt always the best option. I guess it just depends on how well you trust your co-workers.
I will be more than happy to help more if you need it.Just email me at glenda_gable@yahoo.com
by hettymedia
by hettymedia
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending