Disabling "Save as.." button on Read Only database

[daveatthewell]

In our office we have Public Logins, which allow users to access the contents of folders on the network. The folders are Read-only for the Public Login. When a user accesses a MSAccess (2010) file, it naturally opens as Read-Only, but Access advises you of this and asking if you want to do a Save as.. I do not want the users to be able to "Save as.." anything; so is there a way of preventing Access from displaying this alert message?

TIA

 

[alansidman]

Put this in the On Load Event for the Default Form that opens when you launch the database:

DoCmd.SetWarnings False</pre>

 

[daveatthewell]

Thanks Alan, I'll try that on Thursday when I'm next in.