98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · Low Priority · Version Standard
Ruhena has attended:
Access Introduction course
Access
How do I get more than one person to have access to the access database at one time?
RE: Access
Hi Ruhena,
Welcome to the forum and thank you for your post, in answer to your question, the quickest and easiest way to share a database is to ensure first that each user has Access installed on their local computer.
Set up a shared folder where all users are able to access it.
Copy the Access database to the shared folder.
Make sure the Access database is is set to open in shared mode (which is the default setting).
To check if the database is set to shared mode> Tools>Options>Advanced Tab, under Default open mode ensure that Shared is selected.
I hope that helps, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:DsumYou can create percentage values based on individual products / items by using a Dsum function (used with a grouped query) |