you can share a common file (a class say) at a source level between two different solutions by just adding the file (add an existing item) to the appropriate project. The default in vs would be to create a copy of the file in each project that it is added to, but if you look closely the 'open' button on the file selection dialog is actually a drop-down combo, with the last choice being 'link file'. If you use the 'Link file' choice, no copy is created, and the file becomes truly shared between the projects, just like a common header file is used in C++. Absolute faith corrupts as absolutely as absolute power Eric Hoffer All that is necessary for the triumph of evil is that good men do nothing. Edmund Burke

hello just write the query.. select top 1 from tablename where .......... it will fetch only the first record that matches the condition... hope will work for u. bye pankaj

There could be many people accessing the same data at the same time using this application (many instances/copies of my program) Im trying to build (but not accessing the data with some third party application). Im just scared of one thing: - If two different programs, A and B, are running at the same time(both using the same database) and A requests some rows with the DataReader (f.ex. SELECT... where some Boolean == false) and at the same time B updates some of the SAME rows (UPDATE...where ..SET Boolean == true). Is the DataREader in A smart enough to SELECT some rows, and then while looping through them, figure out that one of the rows has been changed (Boolean == true) so it should skip it in the loop? (or are the rows that the DataReader returns just copied into memory and then looped blindly like the DataSet with Adapter.Fill() / Adapter.Update()? ).

If the exception is because you're accessing a remote share, then the workaround would be not to use the remote share--copy the files that are being accessed in the share to the web server. PeterRitchie.com

Yes, you´re right. Im new to ASP.NET programming and I need to read more about it (such as this web.config which I have no idea what´s about) :doh: About the exception, Im simply just catching all exceptions (also OleDb I think) try { ... }catch(Exception ex) { Debug.Fail( ex.Message, ex.Source ); } About this InnterException, I first tried to make a new simple asp.net project which opens an OleDb connections and gets data from one table in an MSSQL database and finally outputs it in a datagrid. It works fine on my local IIS but when i move it online I get this error : System.Security.SecurityException’ I already found something about it on microsoft´s website: http://support.microsoft.com/default.aspx?scid=kb;en-us;320268[^] Do you think the solution would be to put 'FullTrust' rights on my IIS online profile? Many thanks Mike :)