Hello,

I recently deployed an Access 2007 application to a few users to test and they have come up with a scenario I didn't catch when developing/testing. I have a backend password-protected accdb file and the users will access a accdr file.

A form has a combox with the property Limit to List set to Yes. This means that if they type a value not in the list, an error pops up stating the value is invalid and not in the list and to fix it, etc.

Focus goes back to that drop-down because Access won't let the control lose focus because it has an invalid value. Now if the user clicks a Cancel button or some other command that sets focus to another control, the application dies with a runtime error and shuts down.

Any thoughts on how to fix this so that the system doesn't die? If I re-create it using the accdb version I get the debug or end options but the user just gets the Ok button and the application shuts down because they are using a runtime version of the file (accdr).



Any help is greatly appreciated!

PS - Is there any downside to all users having a shortcut to the front-end file and essentially using the same file? I have read about people suggesting everyone gets a copy of the file but haven't found much reasoning behind it. I have split the database into a front end / back end configuration.

Thanks!