I want to use DAO to make updates from a dBase table to an Access table using VB5. Do I create two database objects and then use SQL UPDATE statement? What is the syntax for the SQL statement when I have a database in the dBase format?
Printable View
I want to use DAO to make updates from a dBase table to an Access table using VB5. Do I create two database objects and then use SQL UPDATE statement? What is the syntax for the SQL statement when I have a database in the dBase format?
Well, definately you have to open two database objects; one each for Access and dBase. If you are having problems with SQL Update statement then try rs.Edit and rs.Update commands in DAO.
I am confident this will solve your problem.