I have a spreadsheet that connects to a query in an access database. I was able to update the spreadsheet but now when i click on hte refresh data button i receive an error.

The error says:

Record(s) cannot be read; no read permission on 'Query 1'

I went ahead and tryed to creat a new spreadsheet to see if i could successfully connect to any queries or tables in the same database. I was able to connect to the acccess database with not probelem, but when the window that displays all the tables and queries comes up, i am not able to see all of the tables and queries. I can only see a few.

Also, even if i select one of the objects that i can see, i will still get the same error.

I am pretty much stumped here. If there is anyone with some ideas pelase feel free to help.

Thank you,

Steve G