Using VBA in Excel 2002 , Access 2003 created a report tool .runs well.
until last week we update access2003 to 2007.(excel still 2002).
get error for grammar :" docmd.RunSQL "update .... " "
Error message show "The RunSQL action was canceled."
Reference:
1. Visual Basic for Application
C:\Program Files\Common Files\Micorsoft Shared\VBA\VBE6.DLL
2. OLE Automation
C:\WINDOWS\SYSTEM32\STDOLE2.TLB
3. Microsoft Access 12.0 Object Library
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE12\MSACC.OLB
4. Microsoft Excel DAO Object Library
C:\Program Files\Common Files\Micorsoft Shared\DAO\DAO360.DLL
5. Microsoft ActiveX Data Objects 2.8 Library
C:\Program Files\Common Files\system\ado\msado15.tlb
6. Micorsoft Forms2.0 Object Library
C:\WINDOWS\SYSTEM32\FM20.DLL
7. Micorsoft Office 12.0 Object Library
C:\Program Files\Common Files\Micorsoft Shared\OFFICE12\MSO.DLL
8. Microsoft Excel 10.0 Object Library
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL10.EXE
until last week we update access2003 to 2007.(excel still 2002).
get error for grammar :" docmd.RunSQL "update .... " "
Error message show "The RunSQL action was canceled."
Reference:
1. Visual Basic for Application
C:\Program Files\Common Files\Micorsoft Shared\VBA\VBE6.DLL
2. OLE Automation
C:\WINDOWS\SYSTEM32\STDOLE2.TLB
3. Microsoft Access 12.0 Object Library
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE12\MSACC.OLB
4. Microsoft Excel DAO Object Library
C:\Program Files\Common Files\Micorsoft Shared\DAO\DAO360.DLL
5. Microsoft ActiveX Data Objects 2.8 Library
C:\Program Files\Common Files\system\ado\msado15.tlb
6. Micorsoft Forms2.0 Object Library
C:\WINDOWS\SYSTEM32\FM20.DLL
7. Micorsoft Office 12.0 Object Library
C:\Program Files\Common Files\Micorsoft Shared\OFFICE12\MSO.DLL
8. Microsoft Excel 10.0 Object Library
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL10.EXE