As mentioned this week, many people suggested to deal with views programmatically because of the limitations of the view designer.
So, what I am doing is do create the view in the load of the form. However, to create a view, we need to have a database open. So, I create a database to hold this view. Now, what will happen if 2 users are accessing the form as the same time and do this create view with the same name on the same database? Or, is it like a SQL cursor where it is not related?