Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-15-2018, 06:27 PM   #1
QueryStumped
Newly Registered User
 
Join Date: Mar 2017
Posts: 27
Thanks: 19
Thanked 0 Times in 0 Posts
QueryStumped is on a distinguished road
Shared database with multi users

Hello...needing to ask a question regarding sharing a database with multi users and the same time. Db is located on a shared file folder. Checked the client settings, it is marked as shared. But it will only allow one user in. Please advise

QueryStumped is offline   Reply With Quote
Old 09-15-2018, 07:39 PM   #2
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 1,924
Thanks: 2
Thanked 413 Times in 406 Posts
Cronk will become famous soon enough
Re: Shared database with multi users

Check the settings on your database that it is not by default opening exclusively


Options | Client Settings | Advances


From your post, I assume all users will be using the one database file. If so, you increase the risk of corruption and other problems. Better that each user has their own version which links to data held in the shared backend file. Search front end/backend
Cronk is offline   Reply With Quote
The Following User Says Thank You to Cronk For This Useful Post:
QueryStumped (09-15-2018)
Old 09-15-2018, 07:47 PM   #3
QueryStumped
Newly Registered User
 
Join Date: Mar 2017
Posts: 27
Thanks: 19
Thanked 0 Times in 0 Posts
QueryStumped is on a distinguished road
Re: Shared database with multi users

Thank you for your advice/guidance. I will check once I go back and see what is showing and suggest and alternative. Really appreciate your help.

QueryStumped is offline   Reply With Quote
Old 09-15-2018, 08:35 PM   #4
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,881
Thanks: 55
Thanked 2,195 Times in 2,106 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Shared database with multi users

also you have to allow all rights to the folders property.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
QueryStumped (09-16-2018)
Old 09-15-2018, 09:27 PM   #5
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,591
Thanks: 62
Thanked 1,210 Times in 1,110 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Shared database with multi users

Technically, Arnel, not "all" rights. You need the "MODIFY" group of permissions. You don't actually need FULL CONTROL unless you are the admin for that app and folder AND have the ability to adjust permissions of others. The only "biggie" that FULL CONTROL adds is that you can change ownership of an item. The other things you get with FC aren't quite so drastic in terms of security.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
The Following User Says Thank You to The_Doc_Man For This Useful Post:
QueryStumped (09-16-2018)
Old 09-16-2018, 03:33 AM   #6
QueryStumped
Newly Registered User
 
Join Date: Mar 2017
Posts: 27
Thanks: 19
Thanked 0 Times in 0 Posts
QueryStumped is on a distinguished road
Re: Shared database with multi users

Thank you all for the guidance. It's not allowing me to thank you individually.
QueryStumped is offline   Reply With Quote
Old 09-16-2018, 04:00 AM   #7
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,616
Thanks: 58
Thanked 1,886 Times in 1,836 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Shared database with multi users

You may find more info and examples/articles using Google.
Here is some info from FMS1, FMS2.

__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is offline   Reply With Quote
The Following User Says Thank You to jdraw For This Useful Post:
QueryStumped (09-16-2018)
Old 09-16-2018, 04:42 AM   #8
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,881
Thanks: 55
Thanked 2,195 Times in 2,106 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Shared database with multi users

also you might need to go to advancd sharing on the control panel and set the password to none so that user will not see the ligin screen when they connext to the shared folder.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is online now   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
QueryStumped (09-16-2018)
Old 09-16-2018, 06:40 AM   #9
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,591
Thanks: 62
Thanked 1,210 Times in 1,110 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Shared database with multi users

Good tip, Arnel!
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 09-17-2018, 08:22 PM   #10
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,449
Thanks: 13
Thanked 1,422 Times in 1,355 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: Shared database with multi users

QueryStumped,
Have you split the database so that all the tables are in the BE and everything else is in the FE?

The FE is NEVER shared. Each user has his own personal copy of the FE. Only the BE remains on the server and is shared.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database shared with multiple users zbird General 7 12-03-2012 08:34 AM
Question Shared Database 2010. Won't allow mutiple users Jgent002 General 5 01-29-2012 03:55 PM
Many users on shared drive...one database napsoni Forms 4 01-13-2012 10:47 AM
Access database shared online between two users at no cost - possible? adi2011 General 6 11-27-2011 05:24 AM
2 Users of the database in a shared drive soha General 4 09-11-2007 08:32 PM




All times are GMT -8. The time now is 06:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World