Hi,

I have a big form which the user fills and Data is submitted to Access Database.

I have 4 tables in my database.

On SUBMIT Button in my form, I am using 4 Methods as follows(VB Code) :-

InsertToPersonal()
InsertToProfessional()
InsertToFamily()
InsertToPosition()

First Method Inserts data into Table know as Personal. And Second Method Inserts Data into Professional table and so on.

So, In my every method, I am opening the connection & closing it.
conn.open()
conn.close()

Is this the right approach? Coz on a single Button Click I am opening & closing the connection for more than 4 times.

And Sometimes the User Enter Data in form & Data gets Inserted into first two tables & without showing any Error, Data is not Inserted into 3rd & 4th table.

How to Solve this Problem..??

Help Please.

Thank You......!!

What is such and how it to understand?http://kulinarbook.blogspot.com