By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,084 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,084 IT Pros & Developers. It's quick & easy.

This Recordset is not Updateable Problem

P: n/a
jm
I have a simple query. It has two tables. If I open the tables
separately, I can add records. If I open them up together, the
recordset is not updateable. As best I know, this has never been a
problem it just happened all of a sudden.
- The database has been repaired and converted several times to no
avail.
- All the permissions are correct.
- Copying and pasting the table and query in the same database does
not work.
- Importing the table into another/new database does not work.
- Other combined tables in a query will allow updating.
- I have tried it as Access 2000 and XP.
- I have installed (last resort) the latest SP8 for the Jet database.

Thank you for any help. I can find no settings to cause this
occurrence. I am stumped.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Has the recordset type, or locking been changed? Right click on the query in
design view. It has to be set to one of the Dynaset types in order to be
updateable. Is the DB shared with someone else having locking turned on
somehow?

Mike Storr
www.veraccess.com

"jm" <jo*************@yahoo.com> wrote in message
news:c6*************************@posting.google.co m...
I have a simple query. It has two tables. If I open the tables
separately, I can add records. If I open them up together, the
recordset is not updateable. As best I know, this has never been a
problem it just happened all of a sudden.
- The database has been repaired and converted several times to no
avail.
- All the permissions are correct.
- Copying and pasting the table and query in the same database does
not work.
- Importing the table into another/new database does not work.
- Other combined tables in a query will allow updating.
- I have tried it as Access 2000 and XP.
- I have installed (last resort) the latest SP8 for the Jet database.

Thank you for any help. I can find no settings to cause this
occurrence. I am stumped.

Nov 12 '05 #2

P: n/a
"jm" <jo*************@yahoo.com> wrote in message
news:c6*************************@posting.google.co m...
I have a simple query. It has two tables. If I open the tables
separately, I can add records. If I open them up together, the
recordset is not updateable. As best I know, this has never been a
problem it just happened all of a sudden.
- The database has been repaired and converted several times to no
avail.
- All the permissions are correct.
- Copying and pasting the table and query in the same database does
not work.
- Importing the table into another/new database does not work.
- Other combined tables in a query will allow updating.
- I have tried it as Access 2000 and XP.
- I have installed (last resort) the latest SP8 for the Jet database.

Thank you for any help. I can find no settings to cause this
occurrence. I am stumped.


3 things to look at: indexes, relationships and SQL for the query.

In a typical setup, with 2 related tables, modelling orders with 1 or more
items I might have:
tblOrders: OrdID, OrdDate, OrdNumber, etc
tblOrderItems: ItmID, ItmOrdID, ItmQuantity, etc

If I was having problems deleting from a query based on these tables, I
would first check that my indexes were in place, that is, OrdID and ItmID
being set as the primary key and ItmOrdID being required and indexed but
with duplicates allowed. I would then check Tools>Relationships and check
the relationship between OrdID and ItmOrdID and make sure it is as expected
(I don't know whether you wanted to specify cascading updates and deletes).
If all of that seemed OK but I could still not delete, I would check the SQL
of the query and post it here if I could still not work it out.

Fletcher


Nov 12 '05 #3

P: n/a
jm
It said Dynaset, but it needed to say Dynaset (Inconsistent Updates)I
believe it just said "Dynaset" from being converted from 97 to 2000
(just using the drop down worked.) How it worked until now is a
mystery, but changing this either on the query or the form, and
usually both, worked.

Thank you for the hint.
"Mike Storr" <no****@somewhere.con> wrote in message news:<hN*********************@news20.bellglobal.co m>...
Has the recordset type, or locking been changed? Right click on the query in
design view. It has to be set to one of the Dynaset types in order to be
updateable. Is the DB shared with someone else having locking turned on
somehow?

Mike Storr
www.veraccess.com

"jm" <jo*************@yahoo.com> wrote in message
news:c6*************************@posting.google.co m...
I have a simple query. It has two tables. If I open the tables
separately, I can add records. If I open them up together, the
recordset is not updateable. As best I know, this has never been a
problem it just happened all of a sudden.
- The database has been repaired and converted several times to no
avail.
- All the permissions are correct.
- Copying and pasting the table and query in the same database does
not work.
- Importing the table into another/new database does not work.
- Other combined tables in a query will allow updating.
- I have tried it as Access 2000 and XP.
- I have installed (last resort) the latest SP8 for the Jet database.

Thank you for any help. I can find no settings to cause this
occurrence. I am stumped.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.