How do I connect a DB grid to a secure Access DB

[dynamodc]

Database was originally not secured but I've added user-level security to it. Now having trouble getting the DB grid working. I notice the data control has now property to add a security group to it. Looked at various sites but still can't get it working. Most seem to hint at ADO but don't give me enough information to enable me to get it working. I'm not too good at VB but know Access quite well so I apologise if this is a pathetic question.

Any help/code would be hugely appreciated.

Thanks.

DC

 

[lulo]

I ran into the same problem using DAO.
What I did was first open the database in a global variable for example:

Set ETS_Wsp = DBEngine.CreateWorkspace("", "Admin", "&quot
Set ETS_DBConn = ETS_Wsp.OpenDatabase(DB_Path, False, False, ";pwd=ccioo&quot

after you bypass the open database with password you can drop a datacontrol for your grid.

Hope that helps.

 

[paperguy2]

Check out MS Knowledge Base Article - Q300261