OLT & msmac67 gave you the right idea, but depending on the level of security you need, there are some additional steps you should take.
NOTE:This answer assumes the security level you need does not require {User-Level} security which uses a {workgroup information file}.
1)Create a new database
2)Add {database} security. Search for "security" in the Access Help Answer Wizard, select "Secure A Microsoft Database" (left pane), select "Protect...with a password or encryption" (right pane)
3)Create links to the "real" database for all the tables data you want the end users to view.
4)Create a query for each table, or if you already have the queries in the "real" database, import them. In any case, change the queries' {Recordset Type} property to snapshot.
5)Create a form (i.e., {datasheet view}) for each query. You can select the query, then Insert/Form + AutoForm:Datasheet form the Menubar, and Access will create the form form you.
6)Change the form's {Data/Recordset Type} to "Snapshot". NOTE:This is not theoretically necessary, but it provides an additional level of security if someone decides to try and break security.
7)Create a new {startup} form with cmdButtons to open the enduser viewing forms.
***continued
