Is there a way to prevent data entry into table-only design?

[Guest]

Hello,

I'm sending a modified copy of a live database that contains ONLY the table
design-- no data. There is nothing else included in this version-- no forms,
macros, queries, etc. I'm a bit paranoid, and I was wondering if there is a
way to prevent data from being entered into these tables, while permitting
one to view the design structure of those tables.

Thx,

 

[Rick Brandt]

Hello,

I'm sending a modified copy of a live database that contains ONLY the
table design-- no data. There is nothing else included in this
version-- no forms, macros, queries, etc. I'm a bit paranoid, and I
was wondering if there is a way to prevent data from being entered
into these tables, while permitting one to view the design structure
of those tables.

Thx,

It's a copy and it's empty. Why do you care?

If it's possible at all (I don't think it is) you would have to use User Level
Security to do it. I doubt that there are security settings that allow for
viewing design without allowing data entry, but I could be wrong.

 

[Arvin Meyer [MVP]]

Not really. The granularity of security usually runs the other way: You
don't get to see structure but can see data.

You might just print the report from the Relationships window which would
show all the fields. Or just build a report using my table documentor code:

http://www.datastrat.com/Download/FieldDescription2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access