converted older version

[66motorsport]

I have updated a database from an older version of access and am recieving a
"This recordset is not updateable" message when I'm trying to chage a
record..How can I make all my records capable of being updated?

 

[Allen Browne]

See:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
for a list of possible reasons.

It might be as simple as a missing index on the ONE side of a join.

 

[Jerry Whittle]

Are you trying to change the record directly in the table, through a query,
or in a form?

If a query or form, is more than one table involved?

 

[66motorsport]

I am going into the table and changing one filed of a record....

Thanks
Ed

 

[66motorsport]

Only one file is being used...it it an inventory file I designed of small
race car replicas I collect. I am simply trying to change some data relating
to one item.
However, it does not allow me to change any information of the 457 records
in this database.

 

[Jerry Whittle]

Hummm. I thought that maybe it was a lookup field with limit to list or a
foreign key field but my testing showed different error messages.

Is the database set to read only?
Could other people be using the database at the same time?
Is it only one record, field, or table with the problem?

 

[66motorsport]

I am the only user and my laptop is not currently connected to the net...I
did add a record Sunday evening, even attached a photo to an old record.

Read only? could I have changed a setting to create this? How would I
undo this IF that was the problem.

Currently I can not change any field of any of the records.

Ed V

 

[Jerry Whittle]

First make sure that the database is not running.

Next find the database file using Windows Explorer. Right click on it and go
down to Properties. The Read Only attribute should not be checked.

Next look in the same folder as the database file. Do you see another file
with the same name, but an .ldb suffix? If so delete that file. It could be
locking things up.

If that doesn't work, make a copy of the database file for safe keeping.
Then try a Compact and Repair.

 

[66motorsport]

I just noticed that when I open access with this file, the new records button
and save buttons are grayed out in the "records" section... unlike my other
dtatbases.
I checked the read only and it was not checked,

thanks
Ed

 

[66motorsport]

renamed the table and I worked.....thanks!!!!

Ed V