"can’t replace the current value of the field" error

[JeffL]

I am using Access 2003. When I am trying to replace text, using Replace All
(from edit menu with a table, not in a query) I get the message :

You can’t replace the current value of the field with the replacement text.
Resolve any errors before making further replacements

after 9494 changes. I just go to Replace all again, but it will only let me
change 9494 fields at a time.

What's happening?

 

[Tom van Stiphout]

On Sat, 17 Oct 2009 08:44:01 -0700, JeffL

It appears you're running up against some limitation of Access. Not
one that I'm aware of though. Here is a workaround: do the f&r with an
Update query:
update myTable
set myField = Replace(myField, "aaa", "bbb")

-Tom.
Microsoft Access MVP

 

[Tom Wickerath]

Hi Jeff,

This sounds like some type of memory limitation issue, if you are able to
successfully change X records (X=9494 in your case), but not all records.
Have you tried using an Update query instead of attempting to use the Find
and Replace functionality? To do this, create a Select query that selects
just the records of interest, by applying the proper criteria. Then convert
the query to an Update query, specify the appropriate update to value, and
try running the query.

Of course, before you run any action query on your database, it is
recommended that you have a good backup copy available.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[David MacLean]

Just got Windows 7 Ultimate (to upgrade Windows Vista Ultimate).

Had problems with Microsoft Mail in Vista, and therefore had replaced it
with Windows Live Mail.

When I installed Windows 7, I found that it had installed a new version of
Windows Live Mail. Not really a problem. The problem comes when I opened
it for the first time. I had set a whole bunch of rules to send various
mails into various folders. At first glance, some of the rules did not seem
to run. On further inspection, it was not that the rules hadn't run, but
that the destinations were missing.

Like a good little boy, I went to the Microsoft Web Site to look for
support. Got jammed up on the Product ID. I allowed their ActiveX
component to install on my machine so that it could find the product ID. It
couldn't. Tried to follow the directions on the second option to retrieve
the product id manually, and there ran into a major problem. The first page
of the Control Panel comes up fine when I click Start --> Control Panel but
on any option that I choose, I get a dialog box saying that Internet
Explorer has stopped working, followed by another saying that Internet
Explorer is restarting followed by the desktop.

I went back to my email folders, because I have dealt with Microsoft Support
in the past (and contrary to the horror stories that abound, whenever I have
had dealings with Microsoft Support in the past, it has been professional
and courteous and effective) only to find that most of the mail that I had
been saving is gone. Same goes for other folders.

I am wondering if there is anyway to get to Microsoft Support other than
providing Microsoft with a credit card number for something that should be
free support to a customer????

Dave MacLean
(e-mail address removed)

 

[John W. Vinson]

Just got Windows 7 Ultimate (to upgrade Windows Vista Ultimate).

Had problems with Microsoft Mail in Vista, and therefore had replaced it
with Windows Live Mail.

The Microsoft Help webpage has misled you (as it has many others); this forum
is for the database software Microsoft Access, not for "access to the
internet" or for other Microsoft programs. Please repost your question in a
forum supporting Windows Live Mail.