Replace All Limitation in Access

  • Thread starter Thread starter Hitesh Zinzuwadia
  • Start date Start date
H

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
 
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
Click to expand...

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

Update to

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

and it will do all occurances.
 
Back
Top