johnaregan
Programmer
- Mar 13, 2001
- 87
Can you make a COM file out of Access VBA? Alternatively is how would I call an Access VBA procedure from an SQL Server stored procedure?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
COM
- Thread starter johnaregan
- Start date
- Status
jimmythegeek
Programmer
I am pretty sure you can NOT make a COM object from Access. You can from C++ or Visual Basic, but not Access.
You also can not call a VBA procedure from SQL Server, but you can the other way around (A VBA procedure can call a SQL Server stored procedure). It would be something new to me if you could.
Jim Lunde
compugeeks@hotmail.com
Custom Application Development
You also can not call a VBA procedure from SQL Server, but you can the other way around (A VBA procedure can call a SQL Server stored procedure). It would be something new to me if you could.
Jim Lunde
compugeeks@hotmail.com
Custom Application Development
- Status
Similar threads
- Locked
- Question