|
Home > Archive > General Discussion > August 2002 > A question about MS Access
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
A question about MS Access
|
|
| well0120 2002-08-18, 9:17 pm |
| Can 2 or more users access simultaneously an Access database and make changes? If so, how would that be done?
Thanks a lot! | |
|
|
| thecomeons 2002-08-19, 4:40 am |
| i imagine briefcase or something similar could look after that kind of trick. i agree that mous forum could be the correct place to ask the same question - it mightn't look the busiest forum, but all questions seem to get answered within a few days. maybe you could pm paisley. | |
| chyna1057 2002-08-19, 7:07 am |
| As far as I know, Only the 1st user or the owner of that database has exclusive rights. All others may not be able to open unless they have create/delete privileges to that directory or may only be able to open a "read only" copy. Which is usless if they have to make changes. If I'm not mistaken, permission changes can be changed , just not sure where. I think the properties box in design view. If anyone else knows something different, please let me know. | |
| Teck Shark 2002-08-19, 11:18 am |
| quote:
Originally posted by well0120
Can 2 or more users access simultaneously an Access database and make changes? If so, how would that be done?
Thanks a lot!
Yes, multiple users can access & make changes to an Access Database. You just have to set the default open mode to Shared and not Exclusive. To do this in Access 2000 just open the database you want to share. Then go to Tools, Options, Advanced, and change the default open mode from exclusive to shared. And you should be good to go. We share multiple Access Databases here, some have 15+ users accessing them. So it works great. Good luck, I hope that helps you out! | |
| well0120 2002-08-19, 7:21 pm |
| Thanks a lot! It worked perfectly.
Keep up the good work! Cheers!
quote:
Originally posted by Teck Shark
Yes, multiple users can access & make changes to an Access Database. You just have to set the default open mode to Shared and not Exclusive. To do this in Access 2000 just open the database you want to share. Then go to Tools, Options, Advanced, and change the default open mode from exclusive to shared. And you should be good to go. We share multiple Access Databases here, some have 15+ users accessing them. So it works great. Good luck, I hope that helps you out!
| |
| Teck Shark 2002-08-20, 12:01 am |
| [QUOTE]Originally posted by well0120
[B]Thanks a lot! It worked perfectly.
Keep up the good work! Cheers!
Great! I'm glad to hear I could help you out! Have a great day! |
|
|
|
|