 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2005Prevent table design view
I have a patient database shared among 10 people. Is there any way to prevent these users from going into the design view of the tables? I don't want anyone messing with the table structure. Yes there is. But, how are they viewing the information? Have you tried any startup options? ETC. > I have a patient database shared among 10 people. Is there any way to prevent > these users from going into the design view of the tables? I don't want > anyone messing with the table structure. I can't hide the tables on startup as sometimes the users have to access the information in the tables directly. I tried splitting the database so the tables would be the backend linked to the forms and stuff for users. However, the application worked extremely slow and the users complained. I did not design the database myself. I inherited it when someone left and there is no documentation anywhere as to why he did what he did. > Yes there is. But, how are they viewing the information? Have you tried any > startup options? ETC. > > > I have a patient database shared among 10 people. Is there any way to prevent > > these users from going into the design view of the tables? I don't want > > anyone messing with the table structure. Split your database -- the back-end will hold tables and the front-end will hold everything else. Give your users the front-end. They could still, with perserverence, see the tables, but they won't be able to modify them. Check Access HELP on "splitting" your database. Good luck Jeff Boyce <Access MVP> >I have a patient database shared among 10 people. Is there any way to >prevent > these users from going into the design view of the tables? I don't want > anyone messing with the table structure. I did try splitting the database but the linked front end worked extremely slow and the users complained. > Split your database -- the back-end will hold tables and the front-end will > hold everything else. [quoted text clipped - 12 lines] > > these users from going into the design view of the tables? I don't want > > anyone messing with the table structure. There are many reasons why a split design can be slow. If you want to investigate this further, check Tony's website: http://www.granite.ab.ca/accsmstr.htm  SignatureGood luck Jeff Boyce <Access MVP> > I did try splitting the database but the linked front end worked extremely > slow and the users complained. [quoted text clipped - 15 lines] > > > these users from going into the design view of the tables? I don't want > > > anyone messing with the table structure. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.