Can Access code update dbf records?

[Ted Stilwell]

My employer has a dbf database. The records in it require some sanitation
such as supplier "ABC" should = "A.B.C.". Can I 'UPDATE' the data using the
openrecordset technique?

Sample code would be cherished.

 

[Tom van Stiphout]

On Mon, 25 May 2009 00:02:54 -0400, "Ted Stilwell"

Simply attach a dbf file, and it will become a linked table. Then go
to town with your Update statement. I would not use a recordset if I
could use an Update statement.
DBFs need to have a .dbf extension, and the filename cannot be more
than 8 chars.

-Tom.
Microsoft Access MVP

 

[Mike Painter]

My employer has a dbf database. The records in it require some
sanitation such as supplier "ABC" should = "A.B.C.". Can I 'UPDATE'
the data using the openrecordset technique?

Sample code would be cherished.

Simply attach it. If this is a one time deal search and replace does not
need any code.

 

[Ted Stilwell]

I thank you for your help. So far I have only been able to link simple
tables. The type that contain the categories you populate the complex
tables with. The complex tables return a message that the file is not in
the expected format. Is there a way around that?