Discussion Locked

Custom Program Written in Access 2000

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
What does one specifically need to add to a program written in Access 2000 to make it multi-user compatible? Is this information widely available in a book? What would happen to the existing data in this program (now entered by one user) if many enter information at the same time? The number of users potentially may grow to 10.

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 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

This discussion is closed to new replies.