Hi all,
I'm trying to connect, via OLE Automation, my application to a lock by password an Access data base using ADO. The connection only works if I disable the password in the database itself, then run my application. This situation is not suitable since I do not want the users to be able to enter the database through Access but through my application only. Does anyone now how to be able through a file DSN and OLE Automation to open a lock Access Database? Or does anyone have a simpler solution?

Regards,