<div>
I create a &quot;execute process task&quot;<br />
and in Win32-----&gt;browse to my access db.mdb<br />
Parameter---&gt;&quot;c:\folder_na<wbr />me........<wbr />.Access.md<wbr />b&quot;<br />
<br />
when I try to execute this task its giving me an error msg: general error-2147024703(800700c1)<wbr /> any idea why I am getting this error ?<br />

</div>


I create a "execute process task"
and in Win32----->browse to my access db.mdb
Parameter--->"c:\folder_name.........Access.mdb"

when I try to execute this task its giving me an error msg: general error-2147024703(800700c1) any idea why I am getting this error ?


<div>
<div class="content wysiwyg-content">
Hi,<br />
My objective is to create a DTS task execute process task&nbsp;that will open Access db and once the access db is open it will automatically execute AutoExec macro.<br />
Can you tell me How to open an access database through command line/.bat file ?<br />
How to call that .bat file in my DTS ?<br />

</div>
</div>


Hi,
My objective is to create a DTS task execute process task that will open Access db and once the access db is open it will automatically execute AutoExec macro.
Can you tell me How to open an access database through command line/.bat file ?
How to call that .bat file in my DTS ?


Open Access db through command line

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.