I conducted a speed test on opening a database, some tables and some views, here were my results (from an NT Server):

1 Database 1 Second
8 Tables(some free, some from database 12 Seconds
3 Views (with NODATA) 18 Seconds

My main concern is the views, how come the views take longer to open the tables even with NODATA issued? surely they should be quicker - or is it not?

Comments welcome
Kev