axa2001ro
2004-06-08, 05:06 AM
Hello!
I have a VBA module which is connecting to an Access database. The module is used on two computers:
- one with Windows 98, AutoCAD 2000i and Access 2000
- the other with Windows 2000, AutoCAD 2002 and Access 2000.
In Reference window in both cases I have:
- Visual Basic For Application
- AutoCAD 2000 Type library
- OLE Automation
- Microsoft Froms 2.0 Object Library
- Microsoft Acces 9.0 Object Library
- MIcrosoft DAO 3.51 Object library
The code used to connect to database is this:
Dim WS As Workspace
Dim DB As Database
Dim strDatabasePAth as string
For a few days on computer with Winows 2000 I get the error "ActiveX component can't create object" when I arrive here:
Set WS = DBEngine.Workspaces(0)
Set DB = WS.OpenDatabase(strDatabasePath)
Can you help me, please?
Thank you!
I have a VBA module which is connecting to an Access database. The module is used on two computers:
- one with Windows 98, AutoCAD 2000i and Access 2000
- the other with Windows 2000, AutoCAD 2002 and Access 2000.
In Reference window in both cases I have:
- Visual Basic For Application
- AutoCAD 2000 Type library
- OLE Automation
- Microsoft Froms 2.0 Object Library
- Microsoft Acces 9.0 Object Library
- MIcrosoft DAO 3.51 Object library
The code used to connect to database is this:
Dim WS As Workspace
Dim DB As Database
Dim strDatabasePAth as string
For a few days on computer with Winows 2000 I get the error "ActiveX component can't create object" when I arrive here:
Set WS = DBEngine.Workspaces(0)
Set DB = WS.OpenDatabase(strDatabasePath)
Can you help me, please?
Thank you!