Findind and Replacing data in a table with many reocrds

[makku]

I have table that has more than 2M records, on an Access 97 Access database.

I am trying to replace the letter 'm' in a particular field with 'Me'. I noticed that after an x amount of records Access stops and gives this message: " You can't replace the current value of the field with the replacement text".

I press ok and another message notifing me that I wont be able to undo the Replace operation. I click Yes to go ahead.

As mentioned before only an x amount of records are being replaced. So I have to re-do the find and replace procedure until there are no more records to be replaced.

Is there a way to increase the limit that acess can handle when using the replace function?

 

[vbaInet]

Use an update query and the Replace() function. See what you can do with those.

 

[makku]

I cannot use an update query since i have a problem with case sensitivity eg. I want to specifically change records that have an "m" and not "M".


Therefore i am using "match case" in Find & Replace.


regards,

 

[vbaInet]

The replace function can match case. I think it's a binary comparison. Have a look at these:

http://msdn.microsoft.com/en-us/library/bt3szac5(VS.80).aspx
http://www.techonthenet.com/access/functions/string/replace.php