Readonly a linked table

[mcescher]

I have a table that gets generated every month, and we use as a source
of data for other databases. We link this, but I was wondering if
there is a way to make that linked table read only.

Any ideas?

Thanks so much,
Chris M.

 

[Stefan Hoffmann]

hi Chris,

I have a table that gets generated every month, and we use as a source
of data for other databases. We link this, but I was wondering if
there is a way to make that linked table read only.

Either make the back-end read-only or use a pass-through query instead
of a linked table.


mfG
--> stefan <--

 

[Jeff Boyce]

Chris

Rather than make the linked table read only (which implies someone is
working directly in the tables), how about using a form to display the
record(s) and make the form read-only? You'd have a lot more control over
the application (and the data) if you worked in forms...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[mcescher]

Hi All,
Thanks for the quick answers.

The BE database is Access also, so no passthrough queries.

The table is only used as a source for other queries. Nobody is
really working with the data.

It's not been an issue so far, I just came to the realization that the
data "could" be edited. Hoping to avoid a disaster.

Thanks again,
Chris M.