I've got a button on a form that runs the Compact & Repair facility, using code from the EE site:
Commandbars("menu bar"). _
and this works fine in Win98, XP etc. However, in Vista, if the User Account Control is enabled (which it usually is) it throws up an error message saying that the database file can't be deleted because it is read-only (which it isn't), and then creates a db1.mdb file instead.
Any ideas? I need to keep the action hidden behind a button, and the users do not have a full copy of Access, just the runtime version, so they can't use the normal toolbar way of doing it.