can't edit linked microsoft excel spreadsheet using form 1

[ronrsr]

I developed an application that uses data from excel spreadsheets -- during development, I imported the data, and everything worked just fine - i could edit, change, delete data in all fields.

Now, I changed it so that it works with linked tables from excel spreadsheets -- all of a sudden, i can not edit any of the data!! There is nothing in the docs to indicate that linked tables can't be edited.

Would appreciate any insight you can give me.

Ron at Homebase@world.std.com

thanks,

-rsr-

 

[ronrsr]

THE error message (in the status area) is; recordset is not updateable.

-rsr-

 

[RickSpr]

Try opening the linked table directly and editing it. If you get the message "This recordset is not updatable" in the status bar, check for the following:
1. .XLS file is read-only.
2. .XLS file is on a network share to which you don't have update permissions.

If you get a message box saying "Field can not be updated", test whether the linked worksheet is protected (Tools>Protection menu).

If you can update via the table in Datasheet View, but get "This recordset is not updatable" when updating via a form, your form is probably based on a many-to-many join (either in the underlying query or in an SQL statement in your form's Recordsource property). Access will assume a join is many-to-many unless you define a unique index over the join fields in one table. You can resolve this by creating unique indexes over the join fields in the parent table. Also, go to the Answer Wizard (or Office Assistant) and enter "update data from a query". Read the help topic "When can I update data from a query?".

If this doesn't help you resolve the problem, describe the steps you're taking and the error indication you're receiving.

 

[ronrsr]

thanks, will investigate that further.

The error message is : Recordset not updateable.

The data is a simple excel spreadsheet with simple values -- no data protection, no file-level protection - no SQL as far as I can tell.

how do i tell if the worksheet is the result of table joins?

thanks again,

-rsr-

 

[ronrsr]

Thanks, Rickspr and other-- i discovered the problem. The Excel spreadsheets that were emailed to me were READ-ONLY.

I clicked off the READ-ONLY attribute, and it worked.

Thanks very much,

-rsr-