Can Access code update dbf records?

  • Thread starter Thread starter Ted Stilwell
  • Start date Start date
T

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

Simply attach it. If this is a one time deal search and replace does not
need any code.
 
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?
 
Back
Top