var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Call a sqlserver function/procedure/jon/dts from MSACCESS
This is my first posting here and I hope somebody could help me out with this...
I have created an MSACCESS front-end application with ODBC-linked tables (SqlServer tables) and have made some DTS packages on the SqlServer that would be nice to be able to execute from MSACCESS.
Does anyone have examples of how to call/execute DTS/procedures/functions/jobs on an SqlServer database from MSACCESS?
Is there a reason you're not using an adp?
ADP's are the way to go if you intend to be calling SQL Server's functions et al.