2 Forms connecting to same DB

[flynn]

Given the following setup:

 

3 forms: MDIParent, Child1 and Child2

2 Access tables: Table1 and Table2 (tables are totally unrelated)

 

If I create a global database connection string from MDIParent, can I modify data in Table1 (from Child1) and Table2 (from Child2) using the same connection string at the same time without causing corruptions?

 

tia,

flynn

[Puiu]

If you say the tables aren't related i don't think there will be any problem.

 

You could use Connection pooling also, so that you don't have to open the same connection more than once.

 

A problem could have occured if you'd want to access the same table at same time. For that you would have used deadlock pripority:

 

http://msdn2.microsoft.com/en-us/library/ms186736.aspx