Topics Search

* Using Dynaset(inconsistent Updates) *

* Using Dynaset(inconsistent Updates) *
Views: 12
- I am in a very grey area with respect to updating records. Some of my records in my database are perfectly fine to update, and they retain any changes or data entered well. A small handful of records will allow me to update them, but they do NOT retain the changes or data entered. Here are the symptoms, and actions I've taken:

1. Originally some records would NOT allow any data changes or checkbox changes or for that matter - any type of change to them.

2. Opened the 'Googler' and researched the issue. Found an entry that solved the problem by enabling "Dynaset(Inconsistent Updates)" on BOTH the query and the form used to update records

3. Discovered that I could place checks in check boxes and enter data into fields I couldn't before.

4. Closed database

5. Reopened database and noticed my changes did not "keep". However I still could enter / change data as in step 3. This behavior is only noted in a handful of records. All other recordsbehave normally and retain data and changes

GOAL: To consistently be able to enter data as well as manipulate all controls in all records, including this small set of rebellious records. . . . . . .
Sponsored Links:

More topics

 

Save Changes - inconsistent updates

Preview
I'm currently using a query-by-form search query, and I have it set as Dynaset (inconsistent updates) so the user can also edit records they are searching for.

Every now and then after I make changes to records, it asks me if I want to save. However on closing the query, I randomly receive the "do you want to save" window. I want this window 100% of the time in case of mistakes.

Is this save option hiding somewhere
 

Can't update query

Preview
I had a form that used some Dlookups, but it was really slow, so I changed the form so that it is based on a query that uses subqueries in place of the Dlookups. But now I get an error that the recordset is not updateable.

I googled this error and have tried to sift through the many explanations, I even changed the recordset type of the form and the underlying query to Dynaset (inconsistent updates) and it still doesn't work. Here's a skeleton view of my query:
 

Refresh All goes back to First Record

Preview
In the form I have created, which is recordset type - dynaset (inconsistent updates) - since I have linked in Queries that are based on indeterminate relationships.

I need to click "Refresh All" - since its linked to Queries. When I click "Refresh All" above, it automatically reverts back to the First Record.

How can I keep it on the record in view?

Also - is it possible to have the Form, refresh all on its own, without having to click
 

Upgrade questions, 2003 to 2007

Preview
Using 2007 now as a frontend with Oracle RDMS. Existing 2003 Access .mdb is opened with the new version, 2007. However, adding of records, via a form or query, fails. (Note, it works fine with Access 2003.) The query behind the form and the other query consists of two tables with a one-to-one relationship. (The left-side table contains a foreign key which the right- hand table is the parent table.) The error message is that the Access engine cannot find the record, in the right-side table, with key matching fields.

I have figured out a few different fixes. The first one is to change the query's relationship to one-to-many. The results are still the same since the many side (the right side table) is the parent table, and thus the same set of records are returned by the query. The other solution is to set the form's Recordset Type property from Dynaset to Dynaset (Inconsistent Updates). plus the name of the property's value explains enough.

I have a fix but still have yet to confirm if this is the true fix. Can't find anything on the web. Note: I also converted the database to 2007 but the issue still persists.
 

Updating using form bound to a query

Preview
I have a form whose data comes from a query. This query draws data from four different tables, and I have noticed on this forum that there are issues as to whether you can update records using queries like this.

I am able to update data directly in my query so I thought I had got around the problem. I did this by changing some properties of the query and I think it is the "recordset type" property on the query (changed to "Dynaset (inconsistent updates)") (whatever that is), that is enabling me to do this. However, when I try to change data in my form, it doesn't let me make changes in the fields at all even though I can do so in the query.

I want to be able to make changes to the data in the form FRMPupilAchievementByPiece. Any idea on how I can do this? My query only has inner joins, if that's important. I know a bit, but obviously not enough! Any help appreciated.
(PS I deleted most of the DB in the uploaded copy to reduce its size. Any better way
 

Invisible Controls In Form View/DE "No" Prop Issue

Preview
Yet again, buggy, frustrating, confounding Microsoft has managed to make a horrifyingly simple task inspire me to throw my PC out the window and shortly follow it. Consider this new gem:

I'm not getting existing table records showing up in Form View.

a) There's records in the table.
b) The form's Record Source currently contains one-to-one textbox controls from one table. The only control not sourced to that table is not currently sourced to ANYTHING.
c) The Form "Data Entry" property is set to "No"; the "Recordset Type" is "Dynaset (Inconsistent Updates)".for flexibility; the "Allow Additions" property is set to "Yes".
d) The Form Detail "Visible" property is set to "Yes".

Given those, why in the world would I not be seeing the 14 records in the source table, especially with the "Data Entry" property set to "No"?!
 

New Version of Invisible Controls In Form View/DE "No" Prop Issue

Preview
Yet again, buggy, frustrating, confounding Microsoft has managed to make a horrifyingly simple task inspire me to throw my PC out the window and shortly follow it. Consider this new gem:

I'm not getting existing table records showing up in Form View.

a) There's records in the table.
b) The form's Record Source currently contains one-to-one textbox controls from one table. The only control not sourced to that table is not currently sourced to ANYTHING.
c) The Form "Data Entry" property is set to "No"; the "Recordset Type" is "Dynaset (Inconsistent Updates)".for flexibility; the "Allow Additions" property is set to "Yes".
d) The Form Detail "Visible" property is set to "Yes".

Given those, why in the world would I not be seeing the 14 records in the source table, especially with the "Data Entry" property set to "No"?!

Confounding Mr. Gates. Confounding.

Mucho thanks ahead of time for advice on this normally/supposedly easy, yet persistent fix.
Windows XP, Access 2007, .accdb file
 

How to: Find a Record in a Dynaset-Type or Snapshot-Type DAO Recordset

Preview
Learn how to use the Find methods to locate records in a dynaset-type or snapshot-type recordset.
 

Copy Data From One Table To Another

Preview
I have a database that is messed up somehow.It gives me a error saying that the field can't be updated.After 3 tries it lets me update it. So I created of the tables again with no data ofcourse and now need to get the old data into the new db.

I don't know why but I changed the Recordset Type to Inconsistent Updates and the problem went away. I don't understand but it works.Still I messed up by creating a replica and now I can'tcopy the tables since they have weird names now for some of the fields.
 

Another Permutation of Invisible Form Records

Preview
First, I have a .accdb 2007 form that.

1) Has a query SELECT/FROM record source and a "Dynaset (Inconsistent updates) recordset type.
2) Has controls that are bound to two tables. The two tables have primary keys of the same name and data type.
3) Has one control that is a listbox bound to a query that gets its data from my detail/secondary table.
4) Has no "bound" errors in any control.

My detail table only has two fields. One is a date, which is bound to a date control on the form. I need to repeat one of the fields in this detail table in my master table in order to associate an employee with a code (I know this is poor database structure, but in this case, it needs to be done somehow).

I repeated a field ("code") and made it the primary key in both tables to do this.

In order to populate my master table with the "code" value from my listbox (bound to my detail table), I created an non-enabled form control that issourced to the "code" field in the master table and populates on a lost focus event of the listbox.

The listbox based on the query populates fine.

Secondly, here is my question: Is there anything in the above description that would prevent me from seeing the 15 records in my master table?

There's records in every primary key record in the master and detail tables. The Form "Data Entry" property is set to "No". The Form Detail "Visible" property is set to "Yes". For flexibility; the "Allow Additions" property is set to "Yes".

I know I can't simply change the source control of the form off from a query because it references multiple tables. There seems to be no end to the permutations Microsoft can come up with that cause this problem. Shoddy products - just like Steve Jobs said.