Objects and Security

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
 
G

Golfinray

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

selecting workbook/sheet 3
User Security in Access 5
Access and Excel 2
Many sheets, one DB? 1
Publisher is filling blank lines with data 2
Linking Child Timelines to Multiple Parents 0
Need Suggestions to Eliminate Unplanned Table Behavior 4
check boxes not set when copied 1

Top