General discussion

Locked

Custom Program Written in Access 2000

By hettymedia ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Custom Program Written in Access 2000

by DKlippert In reply to Custom Program Written in ...

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.

Collapse -

Custom Program Written in Access 2000

by hettymedia In reply to Custom Program Written in ...

Thank you so much.

Collapse -

Custom Program Written in Access 2000

by Glenda Gable In reply to Custom Program Written in ...

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

Collapse -

Custom Program Written in Access 2000

by hettymedia In reply to Custom Program Written in ...

Thank you. This was a huge help.

Collapse -

Custom Program Written in Access 2000

by hettymedia In reply to Custom Program Written in ...

This question was closed by the author

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Software Forums