Re: Importing From an Access DB Secured with a Workgroup Information File

Bingo!

Thanks Allan!

Don




"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:OBcmvPOwFHA.212@xxxxxxxxxxxxxxxxxxxxxxx
> Here is a copy of one of my posts from 2003
>
>
> In the DTS designer there is an Access icon to use.
>
>
>
> How can I dynamically set the Access System Database
> (http://www.sqldts.com/default.aspx?241)
>
>
> 1)While creating the DTS package with DTS Import/Export Wizard, choose
> the
> source as Microsoft Access ,choose the file path of the .mdb file, provide
> the user name and password.
> 2) Click on the advanced properties for the provider in the dialogue box
> and for the value Jet OLE DB:System Database, please enter the path to the
> system.mdw file
> for Jet OleDB:Database Password, please enter the admin password for the
> access DB
> 3) Now the transfer should complete succesfully.
>
>
> In case the transfer of data still fails , then things to be checked
> would
> be
> 1)If the file path where the access mdb files are shared has the
> appropriate share permissions
> 2)system.mdw file path is correct and it is the correct system.mdw file
> associated with the database.
>
>
> --
>
>
>
>
>
>
> "Don" <someone@xxxxxxxxxxxxx> wrote in message
> news:ucv9TnFwFHA.612@xxxxxxxxxxxxxxxxxxxx:
>
>> Is it possible to import tables from an Access database which has been
>> secured with a unique Workgroup file (as described in the Access
>> Security
>> FAQ)? I tried doing an import against the table and supplied my
>> username
>> and password. However, DTS returned the error ".......the workgroup
>> information file is missing .......". Checked under the 'Advanced'
>> settings
>> tab, but there did not appear anything where the workgroup file could be
>> specified.
>>
>> Am I barking up the wrong tree with the import? Do I need to export the
>> data to an unsecured database first, then import it?
>>
>> I am a newbie here, so don't hurt me too bad!
>>
>> Thanks!
>>
>> Don
>


.

Relevant Pages

  • Re: Importing From an Access DB Secured with a Workgroup Information File
    ... How can I dynamically set the Access System Database ... 1)While creating the DTS package with DTS Import/Export Wizard, ... 1)If the file path where the access mdb files are shared has the ... Checked under the 'Advanced' settings tab, but there did not appear anything where the workgroup file could be specified. ...
    (microsoft.public.sqlserver.dts)
  • Re: Dynamic DataSource paths?
    ... WORD DID store a static file path. ... stores an "absolute" path to the data source, in this case the .odc file. ... Create your Word doc and save it in the same folder as the mdb file. ... I want to distribute the Database with the Microsoft Word Mail ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Audit of sql server
    ... The DTS database transfer makes sense now. ... >> SQL Server will not check on this for you. ... >> Compiles each query but does not execute it. ...
    (microsoft.public.sqlserver.programming)
  • Advice sought on use of DTS [Long]
    ... I've used DTS for simple tasks for years, ... data from one database to another. ... In my scratch database I keep a mapping of all records I've previously ... Can you programmatically tell a DTS package which databases to update? ...
    (microsoft.public.sqlserver.dts)
  • Re: Newbie need help with DTS, null value error.
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... "Temjin" wrote in message ... > restore my database. ...
    (microsoft.public.sqlserver.dts)