Importing From an Access DB Secured with a Workgroup Information File

Tech-Archive recommends: Speed Up your PC by fixing your registry

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: How do I convert "System.mda" (Access97) to System.mdw ("Access200
    ... > 2.0 Access database) that has a workgroup file called "System.mda" which ... > The conversion will be to Access 2003. ... permissions are not stored in the mda/w; ...
    (microsoft.public.access.security)
  • Re: Help with error code
    ... This error message returned by the Microsoft OLE DB Provider for Jet ... The Microsoft® Access database is not a secured database and the login ... not pointing to the correct Access workgroup file. ...
    (microsoft.public.sqlserver)
  • Re: Point to workgroup file
    ... >> I don't want user to access database my directly ... >> How do I point to my workgroup file programmatically? ... >If your Net app can see & use the workgroup file, ... Thx a lot ...
    (microsoft.public.access.security)
  • Re: Connection String To Access With Workgroup File
    ... Try a single quote around the filename. ... I have a JET DATABASE (better term to use instead of an "Access database") ... Which has the connections strings in the config correctly. ... Access database which uses a workgroup file, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Trying to change ACCESS Password for User!!!!
    ... I have an access database that uses a workgroup file for security. ... Is there a way I can change the user password for this access user name in code??? ... How to Use ADOX to Change Jet User Passwords in Access ...
    (microsoft.public.vb.database)