Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

3 Adodc Control in one form (urgent)

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

Author Comment

ID: 6158020
urgent pleaseeeeee
LVL 15

Expert Comment

ID: 6158083
Please, maintain your other question!

Accepted Solution

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.


Expert Comment

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

Hope this helps
LVL 51

Expert Comment

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

Expert Comment

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

Expert Comment

ID: 7167830
Comment from expert accepted as answer

E-E Moderator

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
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.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

828 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