I have opened the table in Excel and the mode in the definition string is "Mode=Share Deny Write" which is what I want. When I open the table in Access, it opens in read only. I want to be able to make changes in the database using Access but not Excel. When I close Excel and open Access, then I can make changes. What am I doing wrong? I think the whole point of refreshing data is to update Excel to show changes made in the database, but I can't make changes to the database! Help!