Re: Dynamic DTS (Urgent !!!)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

http://www.sqldts.com/default.aspx?210

However, if your MDB file is accessible to the server anyway then you
may want to consider creating a linked server to the database instead
and then importing the data using starndard SQL INSERT statements.

--
David Portas
SQL Server MVP
--

.

Relevant Pages

  • Re: Linked Server to MS Access DB: Login Mapping Error
    ... >connected to a different SQL server in Query Analyzer. ... Under "Linked Server" I put the name I wanted to reference it by. ... Put path to location of database in "Data Source" (in this case, ... >made without using a security context" option was checked. ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Linked server to MsAccess
    ... "All users should typically be accessing the Access database ... with the user Admin and no password. ... This will set the security so anyone using the linked server ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Linked server to MsAccess
    ... This will set the security so anyone using the linked server ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Re: Setting up Linked server to MsAccess
    ... I'm running SQL Server\Express in "Windows Authenication Mode" (Do I have to ... they are accessing my MS Access linked server? ... Containing folders with MSAccess Database X.mdb ... SQl Express has linked server X mapped via UNC to Database X.mdb ...
    (microsoft.public.sqlserver.security)
  • Linked server from SQL Server to Access db on network share?
    ... I have an Access database that exists on a network share ... that I'm trying to link to as a linked server from SQL ...
    (microsoft.public.sqlserver.server)