Making a linked table read-only

[ChrisM]

Hi,

I have a database that contain quite a few tables. Some of which must not be
changed manually. I want to be able to provide the users with the ability to
create and run reports based on these queries. My idea was to create a new
database and create linked tables in this that linked back to the original
database, and to make the links read-only so that the users can report on
the tables, but cannot change anything. I have managed to created the new
database and the links back to the original table, but cannot work out how
to make them read-only.

Any suggestions would be gratefully received.

Thanks,

ChrisM

 

[Larry]

Chris,

You should always separate your data tables from your
forms, queries, reports, etc in another database and link
them. This provides protection of your data in case your
front end database somehow gets corrupted as well as
simplifies the process of making future changes to your
forms, queries and reports.

As for not allowing your users to manually update tables,
let your users navigate through your application via forms
and controls that will allow them to generate the reports
they need rather than having them open reports directly in
the database window. You can create an mde file out of
your front end database and give this to your users. This
will prevent them from seeing your tables directly and
possibly changing data.

Good luck!
Larry