I always used Crystal reports with a defined DSN ODBC connection that worked on temp tables generated runtime before to call my reports and i begun to use alternatively OLEDB connection to use directly my tables without quering them. I have some reports that use both solutions.....Some tables are opened via ODBC and others in OLEDB.....Apparently no problems, but i have a doubt.....When i use tables with OLEDB can i have problems in sharing the tables that i'm using in the reports..are they normally shared or they are locked while crystal reports use them ? I think not, but i ask someone to confirm this.