Objects and Security

  • Thread starter Thread starter Dip
  • Start date Start date
D

Dip

Hi, I have 2 questions for Access databases:-

1) Is it possible to have excel sheets as objects in a table of fields
(primary key) and then link this table to other tables (fields)? Some of the
parameters inside these excel sheets would be the fields.

2) Is it possible to allow some users of Access to view and edit/modify data
or queries, and others to just view and export data, while blocking some
others completely?

Thank you,
Dip
 
1. Yes. Use Excel sheets as linked tables. You can treat linked tables as
regular data as far as queries are concerned. There are certain operations
you can't do with linked tables, such as modify data types. Set the data
types you want in Excel before you link. Then go to get file/get exteral
data/link.
2. Yes. Read the ACCESS security help files carefully. Also go to JMwild.com
and check out Joan Wilds security site.
 
Back
Top