Please Help

[lothos12345]

I am have developed a secure database in Microsoft Access using the built in security wizard. My problem is that everytime I try to connect to the database using ADO.NET for a program that I am developing in Visual Basic.NET I recieve an error. It tells me that I do not have permission to access the database. I do not know how to log on to a secure work group information file for access using ADO.NET. Is there away that I can give my program the permission to access the workgroup information file. Any help with this question would be greatly appreciated.

[Robby]

You can include the Secured.mdw in the connection string...

Make sure that E:\Documents and Settings\Secured.mdw is pointing to where your MDW file is.

 

Also, your UserName, Password and MDB location

 

Provider=Microsoft.Jet.OLEDB.4.0;Password=myPASSWORD;User ID=myUSERNAME;Data Source=E:\Documents and Settings\myDATABASE.mdb;Mode=ReadWrite;Extended Properties="";Jet OLEDB:System database=E:\Documents and Settings\Secured.mdw;Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False

[Kaprisone]

Hello,

 

I know how to connect to a database with a .mdw file but I need to edit users and groups programatically. Is there a way to populate users and groups from a workgroup information file in vb .net and ado.net?

 

Thanks