Using ' for saving

When my address text field has an ' in it, when saving it, it gives me an error.
How do i avoid this problem

Are we talking files or DB's?

This is about the DBs. When Im inserting or updating with a text with the ', i get some error

Do a replace before using the insert/update

VB Code:

.Update ...
     .Fields!Test = Replace(Text1.Text, "'", "''")

:)

Thanx alot .Its working