As described in the Tech Tip "User Mode is now a part of Design Mode", there is no longer a User Mode in 4D v11 SQL. There were some developers who did not only use User Mode in their 4D 2004 and earlier databases as a tool to look at and edit records for the developer, but also as a deployment option. This is not the suggested way to deploy your application, but sometimes it may be necessary to upgrade a database that functions in this way.

This can cause problems in 4D v11 SQL as you must have access to Design Mode to view tables as you used to with User Mode. This means that you would be giving your end users access to your database structure and the ability to change tables, forms, methods, and anything else stored within it. This can obviously be very dangerous.

Keep this in mind when converting databases to 4D v11 SQL. If User Mode was a deployment strategy, it may be necessary to design a menu bar that mirrors the functionality offered in User Mode. This includes Find (Queries), Show All Records, Order by, creating Labels, Quick Reports, Charts and Execute for project methods.