VB4 and DAO 3.6 Update method Compile Error 
Author Message
 VB4 and DAO 3.6 Update method Compile Error

You have to remove the reference to DAO 3.0 and add one to DAO 3.6 in order
to work with the Access 2000 database.

Once you've done that, the "old" Update method in VB4 should be irrelevant.

Doug Steele, Microsoft Access MVP

> I am trying to use VB4 to add a record to an ACCESS 2000
> database. I can open and read the database, but the Update
> method is syntacticly not correct to my compiler. When I
> browse the DAO object/method (Recordset/Update) for DAO
> 3.0 (this is VB4's DAO), I can see that there are no
> arguments for the Update method. When I browse the DAO 3.6
> object/method (Recordset/Update), I notice there are now a
> couple of arguments, which is why I am getting syntax
> error.

> I have searched for hours trying to find how to correct,
> or whether they are just incompatible, but I can't find
> it. I have tried many different things based on the
> articles I found, such as prefixing the objects with DAO,
> but it still does not work. The VB4 compiler just doesn't
> want any arguments with the Update method, and the DAO 3.6
> does.

> Has anyone else encountered this? Is there a means to fix
> or make it work, or must I upgrade to VB5 (I noticed that
> the DAO it uses...3.5...also has the arguments for the
> Update method.

> Thanks for any help offered.

> Rick

Sun, 15 May 2005 07:32:38 GMT  
 [ 1 post ] 

 Relevant Pages 

1. DAO 3.6 errors in VB4 on rs.update

2. DAO 3.6 and FindFirst Method (Error 3251)

3. Findfirst method and DAO 3.6/Jet 4.0

4. Help!! VB4 and Access 2000 (DAO 3.6)

5. Crystal Report Error After Upgrading from DAO 3.51 to 3.6

6. Moving from DAO 3.5 to DAO 3.6

7. Convert DAO 3.5 to DAO 3.6 Jet Engine 4.0

8. DAO 3.6 vs DAO 3.5 (VB6.0 sp3)

9. Reference DAO 3.6 Object Library or DAO 2.5/3.51 Compatibility Library

10. Upgrade from DAO 3.5 to DAO 3.6

11. upgrade from DAO 3.51 to DAO 3.6??

12. DAO 3.51 to DAO 3.6 NULLs question


Powered by phpBB® Forum Software