J
jn
i retrieved this logic from www.mvps.org/access/modules/mdl0030.htm
call application.run ("compacter.docompact",true|false)
true reopens the database, false closes the application.
this works fine when the data base does not have a password. when i add a password, the compact routine closes all tables, forms, queries, reports and when it is almost done, it is finalizing the compacting. i then get the error message
'error 3031 not a valid password'.
how can i solve this issue? i have a routine that after so many days a pop up window appears telling the user to compact the data base. if i take that away, there is no way to compact because it is an mde file and i have eliminated toolbars and methods of getting at the code.
call application.run ("compacter.docompact",true|false)
true reopens the database, false closes the application.
this works fine when the data base does not have a password. when i add a password, the compact routine closes all tables, forms, queries, reports and when it is almost done, it is finalizing the compacting. i then get the error message
'error 3031 not a valid password'.
how can i solve this issue? i have a routine that after so many days a pop up window appears telling the user to compact the data base. if i take that away, there is no way to compact because it is an mde file and i have eliminated toolbars and methods of getting at the code.