MS SQL Server DTS - Importing From an Access DB Secured with a Workgroup Information File

Author

Importing From an Access DB Secured with a Workgroup Information File

Don

2005-09-23, 11:24 am

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

Allan Mitchell

2005-09-24, 7:23 am

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@somewhere.net> wrote in message
news:ucv9TnFwFHA.612@TK2MSFTNGP10.phx.gbl:

> 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

Don

2005-09-24, 1:23 pm

Bingo!

Thanks Allan!

Don

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OBcmvPOwFHA.212@TK2MSFTNGP12.phx.gbl...
> 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@somewhere.net> wrote in message
> news:ucv9TnFwFHA.612@TK2MSFTNGP10.phx.gbl:
>
>

Sponsored Links