I have completed a project using access database. I have used the following connecting method.....
Set wsAccess = DBEngine.Workspaces(0)
Set dbAccess = wsAccess.OpenDatabase(App.Path & "\xxx.mdb")
Set rsAccess = dbAccess.OpenRecordset("SELECT * from t1")
I have used these kind of record set through out my project, extensively. Now I want to impose password for my database. How do I change my code?
Set wsAccess = DBEngine.Workspaces(0)
Set dbAccess = wsAccess.OpenDatabase(App.Path & "\xxx.mdb")
Set rsAccess = dbAccess.OpenRecordset("SELECT * from t1")
I have used these kind of record set through out my project, extensively. Now I want to impose password for my database. How do I change my code?