disable tables ?

[samotek]

Is there any code to make the tables in a database somehow disabled or allowing no edits
as it is in the forms?

 

[KenReay]

Hi

You could set up Access security, and buy selecting the appropriate rights for given users you could make tables readonly to those users

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Pampers]

sure,
set the property of your form that relates to your table to:
AllowEdits = No

Pampers.

You're never too young to learn

 

[GingerR]

Pampers--that still leave the tables themselves editable.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[Pampers]

Hi GingerR
That is right, but users - one of the 10 commandments of Access (databases) - never see tables, let alone edit a table.

http://www.mvps.org/access/tencommandments.htm

Pampers.

You're never too young to learn

 

[GingerR]

Hi Pampers, yes I know the Ten Commandments. But it's all up to the developer. I'm just telling samotek that if s/sh doesn't use Access security, any user can access their tables from the back-end or from a new blank db or from holding down the shift key or from hitting F11 etc etc etc....

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html