Prevent table design view

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 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.
 
I did try splitting the database but the linked front end worked extremely
slow and the users complained.
 
Back
Top