Solved

Conversion to Acc97: Query not updatable anymore

Posted on 1997-12-15
7
227 Views
Last Modified: 2008-03-06
Hi,
having updated our application from Access 95 to Access 97, most of our queries have become un-updatable.

We've corrected this by removing 'DISTINCTROW' from the SQL-statement. (See Knowledge-Base-Article Q168438.)

Now, you may change any entry in a query in the spreadsheet-view of the query, and *partially* you can do so in the form which uses the query as source.

The strange thing is that on *some* computers on which our application is running it's *not* possible to edit any values in the form (in spreadsheet-view still possible); the info in the status-bar is 'This recordset is not updatable' (which corresponds to error 3326).

What could be the cause? Can anyone explain?

TIA, Christoph
mail to: christoph.beuter***@koe2.sni.de (*** to be deleted)
0
Comment
Question by:chrbchrb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 2

Expert Comment

by:BigJ
ID: 1962469
Try double clicking in query design and set the recordset type to "Dynaset - inconsistent updates". This sometimes allows you to edit the returned recordset.

Sorry, can't offer an explanation as to why this might occur.

Good luck.
0
 
LVL 2

Expert Comment

by:BigJ
ID: 1962470
What happended when you set the recordset type to "Dynaset - inconsistent updates"?
0
 

Author Comment

by:chrbchrb
ID: 1962471
Adjusted points to 305
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 1

Expert Comment

by:IanHinson
ID: 1962472
The problem may be caused by the joins in the table relationships being down-graded from fully enforced joins to 'weak' joins.

You can check this by looking at a query which is having problems in the Query Grid.  Does the join appear with 1-'infinity' - or is it represented by a weak join?

If working to a 'back-end' database, refresh the links using the Linked Table Manager add-in.  This must be done when the front-end or back-end is converted to Acc97.

0
 

Author Comment

by:chrbchrb
ID: 1962473
Sorry, but we've already checked all joins, and they seem to be all correct.
We're indeed working with a back-end/front-end architecture, but have already rejoined all tables, too.
We're starting to believe that this strange behaviour is some sort of bug in Access...
0
 
LVL 12

Expert Comment

by:Trygve
ID: 1962474
What happens if you try to autocreate a new form based on the recordsource for one of the forms that gives you the error ?
0
 
LVL 9

Accepted Solution

by:
perove earned 340 total points
ID: 1962475
Check out properties of the query. The "Unique values" must be NO!
perove
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question