Remove or Change Password on database COPY using .Net application

  • Thread starter Thread starter M Harris
  • Start date Start date
M

M Harris

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.
 
¤ 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/library/aa139977(office.10).aspx#acadvsql_advddl


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top