error using find access 2007

Posted on 2008-11-12
Last Modified: 2013-11-29
A app developed in 2003 works ok in 2007 accept for following (which I was able to produce on entirely different app)

If you open a form for editing -then open the built in find replace dialog (either with ctrl H or thru a menu ) then change a field  then use the dialog to find a different record  an error is generated
Run-time error -2147352567 (800200009)
Update or CancelUpdate without addnew or Edit

I have found some info on this with quirks in 2007 as far as filters and searches that reference this error but nothing on the find dialog being open

BTW  I added a menu to explicitly save the record (calling a docmd.runcommand accmdsaverecord ) and if user saves the record this way firast then they can use the find with no problem  this did not act this way in 2003

So  in summation  to duplicate error
1.      Open a form that can be edited
2.       Open find replace dialog (ctrl H) and go to another record
3.      Leave the find replace open
4.      Edit something on found record on form
5.       Do not save record by moving off record or any other way
6.       Click back on find dialog and search for another (existing) record
The error appears
Question by:bczingo
    LVL 84
    I'd say this is likely a bug in 2007, especially since it's repeatable (note: I haven't tried it, as I try to stay as far from 2007 as possible). It would seem to me that the Find dialog would function regardless of whether you've edited a record or not (and, as you say, this was the case in earlier versions).

    The obvious answer is to not use the builtin Find methods, but that's not feasible for most people.

    Unless you get another solution to this, I'd say contact MS with this report, including explicit details as to how to repeat this problem.
    LVL 3

    Author Comment

    Thanks - u r probably right (about bug)- I'm a consultant  for a state DOT - We upgraded across the board to 2007 and I have the joy to help maintain 500+ access legacy apps. Was able to make most behave like 2003 with command bars and no ribbons but have come across a few bugs like this that seem somewhat insurmountable. I havent much faith in MS support for Access since being told by them they didnt realize command bars didnt work any more! Lol! My theory is all the original architects of Office are long gone  Ca$hed in! GBT!

    Anyway  Gonna keep ? open for a few days to see if any othe experts have thoughts
    Thanks again
    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    Even before this, many people, did not reccommend using the Replace Utility to change values in your tables.
    This utility ignores Referential Integrity, and can result in scrambled data.
    (It also cannot work on conditions)

    If you want to change/Edit/Update values in your tables, create an interface that uses an Update query.

    LVL 3

    Author Comment

    Thanks for comment Jeff 
    Actually the users dont use the replace - they actually click on form behind the find dialog and (the find of course looses focus but stays on top) update a bound control - then click back on find to move to a new record with a new find- Yes - they should just close the find but they have 5+ years of doing it this way with previous versions-
    The reason I said find/replace is that the existing toolbar menu item which they use to begin calls find/replace-
    It is interesting that calling the find dialog actually triggers a before update on a dirty form (didnt think it should and thought I was on to something  however in tests in 2003 it also does this)

    LVL 74

    Expert Comment

    by:Jeffrey Coachman

    OK, so if this is in fact a "Bug" in 2007, then there is really no way around it.

    So your options are:
    1. Wait and hope that MS fixes this in an update.
    2. Live with it.
    3. Build you own form.
    4. Only use Access 2003.

    LVL 3

    Author Comment

    Thanks Jeff
    gonna wait a little longer until someone at least trys this
    got another titled "FTP in Access 2007 no longer works"-if you could look at that Jef I would certainly appreciate it
    LVL 84

    Accepted Solution

    Actually, your question was answered - this is almost certainly a bug. We can't really help this - we didn't write the code for Access 2007, after all - and thus your question was answered, and points should be awarded. You were also given a possible workaround - build your own F&R utility.

    In that respect, I'd object to this closure, but I'll not formally object to it yet.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    VB Access SQL question 2 17
    MsgBox 2 29
    Printing Problem 13 21
    message box in access 4 22
    This very simple solution applies to a narrow cross-section of the "needs to close" variety. In this case, the full message in Event Viewer was in applog, Event ID 1000: Faulting application iexplore.exe, version 8.0.6001.18702, faulting module …
    User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  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.
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    733 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now