DLL usage - works in Access 97 but not in Access 2000 
Author Message
 DLL usage - works in Access 97 but not in Access 2000

The following code workst perfectly in Access 97, but
gives an error in Access 2000: 'Cannot find vba332.dll'.
If I give the complete path to the file, Access crashes.
The same function can also be found in vbacv20.dll, wich
comes with Access 2000, but this won't work either.

I'm getting pretty frustrated. Can anyone help.
Thanks,
Arnold

---------------------------------------
Private Declare Function EbExecuteLine Lib "vba332.dll"
(ByVal StringToExec As Long, ByVal Any1 As Long, ByVal
Any2 As Long, ByVal CheckOnly As Long) As Long

Function ExecuteCode(Code As String, Optional CheckOnly As
Boolean) As Boolean
    ExecuteCode = EbExecuteLine(StrPtr(Code), 0&, 0&,
CheckOnly) = 0
End Function

Sub test()
    Call MsgBox("TJA")
End Sub

Sub ScriptTest()
    Call ExecuteCode("test")
End Sub



Sun, 09 Jan 2005 22:28:10 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Correlated subquery in DELETE stmt not work in Access '97 or 2000

2. Program from access 97 won't work in access 2000

3. Link Failure in Access 2000 that works in Access 97

4. Getting back the formatted MsgBox in Access 2000 that worked in Access 97

5. Access 97 VBA modifications not visible in Access 2000

6. Access 97 upgrade to Access 2000 or Access 2002

7. Access 2000 VBA code not working Access 2002

8. Code from Access 2.0 not working in Access 2000

9. How to get Access 97 (built on a Windows 2000) to work on 95s and 98s

10. Best method of working with Access 97 / Outlook 2000 / Exchange Server 5.5

11. SQL string not works in VB and works in Access 2000

12. Conversion error from Access 2000 to Access 97

 

 
Powered by phpBB® Forum Software