linked tables

[Guest]

I have a LINKED table that has hundres of project names and data. I want to
only pull the names and data for about half. The table is linked to a nother
Access DB table.

How do I ...
1. Pull only the project names and data that I need
2. Prevent changes to the Project names to the linked DB. I do not want
anyone to be able to change the data in the origional table.

Thanks

 

[Guest]

1. Create a query that pulls just the data that you need and base all forms
and reports off of it.

2. Modify the query created above by going to View, Totals in design view.
That will stop the query or any forms based upon it from being able to
modify, delete, or add data to the linked table.

Now if you don't want anyone to get to the linked table, that will take user
level security which is very difficult to set up and maintain.

You could cheat a little by right clicking on the linked table and selecting
Properties. Check the Hidden option.