Replace All Limitation in Access

[Hitesh Zinzuwadia]

Hi,

I have one question.

If you have more than 5000 records in your table and if
you run "Replace All" command for certain field values it
will not replace all in one execution, you will have to
keep on searching & executing Replace ALl untill you get
the message "Search string not found" to make sure all the
intended values have been Replaced.

Is it a limitation on access Database(I use access 2000).

Thank you.
HItesh

 

[John Vinson]

If you have more than 5000 records in your table and if
you run "Replace All" command for certain field values it
will not replace all in one execution

So? Don't use Replace All; run an Update query instead.

Update to

=Replace([fieldname], "oldvalue", "newvalue")

and it will do all occurances.