>I have a database which have 50+ tables and views.
>
>When I open the database, it is really confuse.
>
>I plan to keep tables in 1 database and views in other.
>
>Any advice??
>
>TIA.
I highly recommend keeping your views in a separate DBC from your tables. I also recommend creating the views and their DBC in code, so that they are easily recreated if your data structure changes. Another advantage of separating views into a separate DBC is that you can put this DBC on each user's local hard drive when the program starts up, thereby avoiding any conflicts if two users try to open a view at the same time.
I have an example of how to create views in code on my web site at
www.peisch.com. Click on the Downloads button and select the MakeView.zip link.