Forum Discussion
roguefem
Jul 07, 2020Copper Contributor
How do I share my Office 365 access database with my MS Office Family?
I've built a database now I need to share it with the group. How do I do it?
RJamis2020
Jul 28, 2020Copper Contributor
I had tried replying on a different thread but was unable to actually submit via that form. I hope this post is appropriate here.
I found the comments in this post super helpful.
I have, what I consider to be, a small Relational DB
8 Static Tbls. tbl1 related to tbl2, tbl2 related to tbl3 ... tbl5 related to (Joining tbl6) tbl7 related to tbl6. & tbl4 related to tbl8. The design for those 8 tables shouldn't "air quotes" change ever. the problem that I would have is having to create a button that would generate a form that would allow Mgmt to create tables with columns they or I would create on the fly. Given the fact all of members in out team live across the US, an RDP solution would have to be the way to go. How instantaneous, or not, would the change to the DB be made if a team member claimed a record to edit it?
My question makes sense to me, but it may not to anyone else.
Any 1 of 15+ people will be editing a set of data. No 2 people should edit the same record.
If a column named claimed = Yes once a person clicks the Claimed button, how soon after the click will the change occur in the DB given the RDP solution.
I hope this all makes sense and that I can pull off the Access solution b/c I'm not much of a developer. Thank you for any advice you can provide.
Jul 29, 2020
I would NEVER give users the ability to create tables on the fly, EVER! This is a recipe for disaster.
Database design needs to be managed, properly thought out our else you'll end up with a total mess and people will blame Access our you for all the problems.
Think long and hard before continuing down this path any further.
As for how instantaneous changes are... in a split database the changes are reflected almost instantaneously. Once the user save there changes, moves to another record, close the form, ... the change is committed and available to other users. That is the beauty of a multi-user database.
- RJamis2020Jul 31, 2020Copper Contributor
Thank you kindly for the reply. I appreciate you.
I had considered the "Allowing Management the ability to create tables on the fly via a form" and wasn't too sold on the idea. Going to have to table that for now as it's not something I agreed to do.
If I may, one further question. Can you pleas shoot me a link to the best instructions you have seen for connecting SQL Server Express to Access. I'm trying to develop with scalability in mind from the get go.
Thanks again.