Making a table read-only

  • Thread starter Thread starter Peter Jay Salzman
  • Start date Start date
P

Peter Jay Salzman

Hi all,

I have some tables that I don't want changed by some errant query or
blunder with a form.

Is there a way of making a table read only?

I looked for a write protection notch, but couldn't find it. ;)

Thanks,
Pete
 
Peter said:
Hi all,

I have some tables that I don't want changed by some errant query or
blunder with a form.

Is there a way of making a table read only?

I looked for a write protection notch, but couldn't find it. ;)

Thanks,
Pete
Click to expand...

You have to make it so that users can't edit your tables directly. There are
plenty of control mechanisms availble in forms like snapshot datasets and
locked fields etc.
 
Damien McBain said:
You have to make it so that users can't edit your tables directly. There are
plenty of control mechanisms availble in forms like snapshot datasets and
locked fields etc.
Click to expand...

I'm the only user. How do I protect it from myself? :)

I don't really use forms at all. People ask me for statistics based on
files that are spit out by our mainframe. I import these files into
Access, query them, and report the numbers that were asked for.

Is there a way to actually mark a table itself as read only?

Thanks,
Pete
 
Is there a way to actually mark a table itself as read only?
Click to expand...

You can implement Access Security on your database; define two users
(one with read only privileges, one with read/write). Log on as the
latter to import your data, the former to read it.

This may really be overkill for what's essentially a simple problem
though; you can just use Access' AutoForm on the table to create a
form. Open the form in design view and set its Allow Updates property
to False, then use the form for your searching.
 
John said:
You can implement Access Security on your database; define two users
(one with read only privileges, one with read/write). Log on as the
latter to import your data, the former to read it.

This may really be overkill for what's essentially a simple problem
though; you can just use Access' AutoForm on the table to create a
form. Open the form in design view and set its Allow Updates property
to False, then use the form for your searching.
Click to expand...

....and it sounds like Excel may be better for that (provided you gave less
than 65000ish records)
 
Back
Top