Access Security for window based
-
We have Access 2003, and we secured a database using "User Level Security Wizard". Now we have 2 ".mdw" files, the original one which we used to secure the database, and another one that is created when we open the database. Through connection string we open the database using the original one. My question is.. is there a way to open the database using the other ".mdw" (the one that is created by access when the databse opens) as this is the one that really enforce the security on the file. Bare in mind that this is a windows application class so everyone will have a copy of the original ".mdw" to be able to connect to the database...
-
We have Access 2003, and we secured a database using "User Level Security Wizard". Now we have 2 ".mdw" files, the original one which we used to secure the database, and another one that is created when we open the database. Through connection string we open the database using the original one. My question is.. is there a way to open the database using the other ".mdw" (the one that is created by access when the databse opens) as this is the one that really enforce the security on the file. Bare in mind that this is a windows application class so everyone will have a copy of the original ".mdw" to be able to connect to the database...
In the connection string you can specify the path to the correct MDW file using the "System Database" property, like:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4; "
- "User ID=anon;Password=;Data Source=C:\Data\Database.mdb; "
- "System Database=C:\Data\Users.mdw");
Any further questions specific to ADO.NET please post in the ADO.NET forum. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog]