Just an FYI...I don't know how to do this with Excel and not sure how to do it directly within Access itself...but I do know it's possible from Word and also from an ASP page on the web. So it's probably possible the other two ways, too. You just need to run a query that would create a recordset of only those items that meet the criteria of the agents, such as their matched ID number. Then display those results. Dian Chapman Technical Consultant, Instructor, Microsoft MVP & TechTrax Editor Word AutoForm/VBA eBook: http://www.mousetrax.com/books.html Tutorial web site: http://www.mousetrax.com/techpage.html TechTrax Ezine: http://www.mousetrax.com/techtrax/ -----Original Message----- From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Renaud, Parker Sent: Thursday, September 12, 2002 12:45 PM To: Microsoft Office Group (E-mail) Subject: [mso] Excel / Access Security The head of our commercial leasing department has requested that I create a database or spreadsheet for information on leased properties, including square footages, tenants, lease terms, expiration dates, owner, leasing agent, etc., etc. That is no problem, but the kicker is that he wants secure the information so that he and I have access to all of the information, but the individual leasing agents only have access to the information for properties on which they are the leasing agent and to the statistical summaries. Is that possible in Excel or Access? I appreciate your help on this. Parker Renaud prenaud@xxxxxxxxxxxxxxxxxx "Not all who wander are lost" ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************