Solved

3 Adodc Control in one form (urgent)

Posted on 2001-06-05
7
167 Views
Last Modified: 2010-05-02
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
0
Comment
Question by:Faris
7 Comments
 

Author Comment

by:Faris
ID: 6158020
urgent pleaseeeeee
0
 
LVL 15

Expert Comment

by:ameba
ID: 6158083
Please, maintain your other question!
0
 
LVL 6

Accepted Solution

by:
kahlean earned 20 total points
ID: 6158108
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 3

Expert Comment

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

Hope this helps
Ivanc
0
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 6158249
what is error?
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7132933
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
 
LVL 1

Expert Comment

by:Computer101
ID: 7167830
Comment from expert accepted as answer

Computer101
E-E Moderator
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now