If someone has my app opened and I need to modify a table I have to get everyone off the app so I can.

I am in the process of re-writing my app to make it better. I will use views for the user to interface with instead of the tables directly.

I still have the problem above with the views. How can I set this up so I can do modifications the tables while the app is in use?