Find & Replace

[Guest]

Is there a limit on the number of rows that access will find and replace. I
am trying to replace a single character in a very large database for a single
column. Access will only find the first 9494 lines and then stop. Is this
the limit or is there away to replace all? Thanks for any help you can give
me.

 

[Guest]

Rather than use the Find and Replace feature, write a query to do the work.

For example. Suppose your column has the following:

blam
blam
blue

And you want to update the "blam" to become "boom", your query would read:

UPDATE Table1 SET Table1.Field1 = Left([Field1],1)+"oo"+Right([Field1],1)
WHERE (((Table1.Field1) Like "?la?"));