Permissions In Excel

[MikeDBMan]

I open tables from an Access 2010 (.accdb) database in Excel. When I do I see these access permissions:
Read
ReadWrite
Share Deny None
Share Deny Read
Share Deny Write
Share Exclusive
Write Only



I wish to have a user in Access be able to modify the tables even while people in Excel have files open with the tables displayed. I wish the tables in Excel to be "refreshable". So which permission do I select? Thanks!
I am using Excel and Acess 2010.

[NTC]

while an excel sheet can be a table for Access; excel isn't a front end for an Access table. and you can't have multiple people directly in the same table at the same time in Access - - you need to split the db and use a form Front End for multi user environments.

Not giving you what you seek - but I hope this helps.

[MikeDBMan]

I think you may not be correct. I set their mode in Excel to "Share Deny None" and as long as I open only tables, not forms in Access, I can save changes in Access WHILE the file is open in Excel. If I hit Refresh for the link or wait till it auto-refreshes the changes "pop" into Excel too. This is exactly what I want. Do you know why a form would be different from the "straight" table in Access regarding the permissions. I am sure it is some kind of rights thing in Access but I am unfamiliar. Appreciate your help!