Read Only excel spreadsheet linked to Access

G

Guest

I have an excel sheet linked to an access database but it is setup as read
only(and must stay that way), It will not allow me to run queries...(I keep
getting an error message). Is there a simple way (I don't write code well) to
do this while keeping it read only?
 
D

Duane Hookom

Install all the latest Office service packs should work. The ability to edit
has been removed.
 
D

Duane Hookom

What do you mean by "will not allow me to run queries"?
Do you have some SQL that you could share?
 
G

Guest

Thanks for your help...Did more investigating and made a change with the
permissions of the Excel sheet (from exclusive to shared and kept the
password protection) now everything is working great!

Kathy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Excel Into Access Issue 1
Refreshing Data Daily From a Linked Excel Spreadsheet 4
Excel linked table 6
Linked spreadsheet is read-only 3
Record-Locking remains open after closing 0
linked worksheet connection error 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
query is not updatable;; urgent 1

Top