VBA hide password window in access 2003[modified]
-
hi all. i create a database in access 2003 and i made a password for opening. so when i open the base the user has to type the password. i made a macro which i called it Autoexec and i add on it the action runcode which is like this: Dim db as Dao.DataBase Set db = DBEngine.OpenDatabase("C:\MaBase.mdb", False, False, ";pwd=password") db.Close i wrote this code in order to hide the password window when i open the base. but it stills appear so does someone may help me to hide the pessword window? thanks -- modified at 4:37 Wednesday 2nd August, 2006
-
hi all. i create a database in access 2003 and i made a password for opening. so when i open the base the user has to type the password. i made a macro which i called it Autoexec and i add on it the action runcode which is like this: Dim db as Dao.DataBase Set db = DBEngine.OpenDatabase("C:\MaBase.mdb", False, False, ";pwd=password") db.Close i wrote this code in order to hide the password window when i open the base. but it stills appear so does someone may help me to hide the pessword window? thanks -- modified at 4:37 Wednesday 2nd August, 2006
Are you trying to open a password protected access database from VB.NET? One thing to remember, if you have the database set to 'compact on close' the password window will re-appear. Steve