I don't know if anyone has come across this. I am using Access 97. I have a menu option for users to compact databses, as they get very large during use. It has always worked flawlessly in the past, i.e. on clicking the menu item the database compacts and reopens.
Now, when they click the menu item, Access asks for the file to compact (with Open Dialog) and the file to compact to (with Save As Dialog). It will not allow the current database to be compacted as it is open.
As the databases are secured, the Tools -> Database Utilities -> Compact Database option is not viable, and I do not want the users to have to do this anyway. Does anyone have any ideas as to why this worked before but no longer does. I have not changed any code so it is a bit of a mystery.
Have fun!
)
Alex Middleton
Now, when they click the menu item, Access asks for the file to compact (with Open Dialog) and the file to compact to (with Save As Dialog). It will not allow the current database to be compacted as it is open.
As the databases are secured, the Tools -> Database Utilities -> Compact Database option is not viable, and I do not want the users to have to do this anyway. Does anyone have any ideas as to why this worked before but no longer does. I have not changed any code so it is a bit of a mystery.
Have fun!
Alex Middleton