473,320 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

how to connect to msaccess through VB using ADODC

Hi,

i'm facing one problem from 3 days.i'm unable to connect to MSAcess using ADODC control in VB please reply as soon as possible.
Aug 23 '07 #1
3 7836
vinci
62
Hi,

i'm facing one problem from 3 days.i'm unable to connect to MSAcess using ADODC control in VB please reply as soon as possible.
i guess u already added the ADODC control on your form...

first thing u do is to right click the control and select the ADODC properties
then u choose whether ul use connection string, ODBC, or UDL

connection string(CS) is the easiest so will do CS:
select "use connection string" radio button then click build

select the path of ur access dbase..if ur dbase has a uname and password , just type in the uname/pwd on the field provided...

then in the provider tab u select "Microsoft Jet 4.0 Ole DB Provider" then click ok...

basically thats how u connect to ur access dbase...

hope u got it! Enjoy Coding!
Aug 24 '07 #2
Add the MIcrosoft ADO Data control 6.0 (OLEDB) in your component, then after that drag it to your form then right click the adodc control then,

1.Select adodc properties
2.select the Use connection string, then click build and select yor database for the connection
3.then in the provider tab u select "Microsoft Jet 4.0 Ole DB Provider"
3.then go to the recordsource tab, then choose the commandtype to adcmdtext
4.and then in command text sql, type the query e.g. Select * from tablename

5. then click apply and ok
6.then you are now connected to your database


Happy Coding..

Slapshock
Aug 24 '07 #3
Dököll
2,364 Expert 2GB
Additional info just in case of a report:

http://www.thescripts.com/forum/thre...65-adodc1.html

You may find added examples through Search term above, simply add adodc or ado.

Good luck with the project!
Aug 24 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Raoul Watson | last post by:
I have a form with an AdoDc control associated to a datagrid. The AdoDC uses a "ConnectionString" such as "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=..." this is...
17
by: kartheek | last post by:
hi friends, can any one out here help me by giving me the code to connect to an MSACCESS database using javascript.
1
by: taimoor | last post by:
hello to every one i m in learning process now i want to know that how we bind the data combo with msacees like we bind text box with msaccess using adodc or data environment or code library
1
by: GNoter | last post by:
Scenario: I've a WebFarm with 2 web servers which are NLBs (network load balanced). Web1 and Web2; they are not part of a domain. I have a third server, Server3, which is part of a domain and on...
0
by: jackvel | last post by:
Hi Dudes... I want to connect the Access database with VB 6.0 without using DataControl and ADODC.. Which option should i use.? Plz send me the detailed procedure of doing the same.. Plz...
3
by: Zelalem | last post by:
Help me to connect VB Programming 6 and MS-Access without using ADODC. Thank you in advance
11
by: Mishika9486 | last post by:
Hi pals.. i hav developed an application in vb nd am tryin to connect using oracle.. it gives the following error using ADODC and ODBC "test connection failure because of an error in...
9
vikas1111
by: vikas1111 | last post by:
How to connect visual basic to access database without using adodc...
4
by: psyvanz | last post by:
Im a college student, my program is a computerized enrollment system, Im using MS ACCESS database in connecting my VB6 program form. Inside i'd created two tables, named "tbstudentinfo" and...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.