Remove or Change Password on database COPY using .Net application

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • M Harris
    #1

    Remove or Change Password on database COPY using .Net application

    I have a production database that is password protected. Through my
    application, I want to provide the users with a COPY of this database,
    including RI, without a password or at least a different password than the
    production database has. Is this possible? If so, how? I am using an
    Access 2000 database with Jet Engine 4.0 and Visual Studio 2005.


    Tags: None
    • Paul Clement
      #2
      Re: Remove or Change Password on database COPY using .Net application

      On Thu, 10 May 2007 14:00:52 -0500, "M Harris" <mharris@revenu e.state.il.uswr ote:

      ¤ I have a production database that is password protected. Through my
      ¤ application, I want to provide the users with a COPY of this database,
      ¤ including RI, without a password or at least a different password than the
      ¤ production database has. Is this possible? If so, how? I am using an
      ¤ Access 2000 database with Jet Engine 4.0 and Visual Studio 2005.
      ¤

      You should be able to create a copy and then run SQL DDL (using ADO.NET) to remove the password. See
      the Share-Level Security section in the following article:

      http://msdn2.microsoft.com/en-us/lib...cadvsql_advddl


      Paul
      ~~~~
      Microsoft MVP (Visual Basic)

        Comment

        Previous template Next
        Working...