Unanswered: Record(s) cannot be read; no read permission on 'Query 1'
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.