3 Adodc Control in one form (urgent)

Hi
  I have a problem in saving my records as I have (3) adodc controlls in one form and when I come to save an error occurs pleaaaaase help me to save my records
P.s Im using access also I have 2 comboboxes and 3 normal text boxs
thanks
FarisAsked:
Who is Participating?
 
kahleanCommented:
you can have mutiple adodc control on a form but each control can have a connection to the database at a time. You can not have all your adodc accessing the same database at the same time. Try to maintain with a single adodc will be good eniough

0
 
FarisAuthor Commented:
urgent pleaseeeeee
0
 
amebaCommented:
Please, maintain your other question!
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
ivancCommented:
Faris
To get to different tables of the same database you can create multiple recordset via one ADODC connection.

Hope this helps
Ivanc
0
 
Ryan ChongCommented:
what is error?
0
 
DanRollinsCommented:
Hi Faris,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will suggest to:

    Accept kahlean's comment(s) as an answer.

Faris, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will follow up.

EXPERTS: If you disagree with my recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
Computer101Commented:
Comment from expert accepted as answer

Computer101
E-E Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.