2 Forms connecting to same DB

F

flynn

Well-known member
Joined
Jul 28, 2005
Messages
58
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
 
If you say the tables arent related i dont think there will be any problem.

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

A problem could have occured if youd 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
 
Back
Top