Visual Basic :: Tutorial On Populating A DataGrid With Data From A Microsoft Access Database

Saving Data To Microsoft Access Database ( Couple Of Questions )
Hey Guys

  I trying to use Microsoft Access as my Database on my Pocket PC 2002. The only problem is that I don't know how to do my connection. Right now I'm using SQLCE but it giving me problem when I try to Insert data into the Table manually.

This are the code I use to connecto my my SQLCE database table.

           Code:Import system.Data
Import system.Data.SQLCE

   'Connection to the Database
        Dim MyConnection As SqlCeConnection = New SqlCeConnection("Data Source=My DocumentsADP.sdf")
        Dim MyDataAdapter As New SqlCeDataAdapter
        Dim MyDataSet As New DataSet

        'This give the Status of the user depending on the User ID enter in the
        'Textbox called txtUserID
        Dim Status As String

        Try

            MyDataAdapter.SelectCommand = New SqlCeCommand
            MyDataAdapter.SelectCommand.Connection = MyConnection
            Status = MyDataAdapter.Selectcommand.commandText = "Select UserStatus from Users WHERE UserID = '" & txtUserID.Text & "'"

            MyConnection.Open()
            MyDataAdapter.SelectCommand.ExecuteScalar()

        Catch EX As Exception
            lblErrorMessage.Text = (ex.Message)
        End Try

        MyConnection.Close()

1) How could I connect to my access Database??

2) Where would I located or transfer my Database file too on my Pocket PC??? Would I place it in My Document or some where else???

3) What type of file should I convert it to???? I know SQLCe uses .sdf.
4) What I be able to do Query with my Access Database???
5) Would I be able to Insert, Delete, Update, my Access database once it's upload to my pocket pc??

Thanks Guys

Thanks

Sincerely; Oscar Martinez

Edited by - youngOz on 8/5/2004 9:55:28 PM

Puting Data Into A DataBase (VB6, ADO, ACCESS, DataGrid)
Old in basic/vb but new to this part of database with VB6.

Have created an ACESS Database with several tabels.

Have a VB6 project with several forms.
ACESS, ADO, Jet 4.0 and DataGrid.

If I make a textbox and connect it to the database and say
DataBase.Recordset.AddNew
then I can add text into that textbox and this goes into that database.
So far no problem.

But now I want a value I have in a string, TextString, to be put into the database. In fact I have several such strings I want to be put into various Fields in the new Data.

But I am not able to.

Have tryed to put this text into the TextBox. But this does not get transfered into the database. Strange to me as if I type "manually" it does.
Maybee some settings or ---
So how can I send a textstring direct to a field in the database?

Have a nice day
Per

Populating A Datagrid From A Database Table
Hi All,

I currently have a working program which populates data into a ListBox using .AddItem but i want to change it to a DataGrid and I'm not sure how to populate the fields.

I have Module file which has the following procedures to handle Database Connections

Code:
Public Sub Connection()
CConnect.ConnectionString = "TimesheetData"
CConnect.Open
End Sub

Public Sub JobsRecordset()
JobsRecSet.ActiveConnection = "DSN=TimesheetData"
JobsRecSet.Source = "Select * FROM Jobs ORDER BY JobCode ASC"
JobsRecSet.Open "Jobs", CConnect, adOpenDynamic, adLockOptimistic
End Sub

Public Sub CloseJobsRecSet()
JobsRecSet.Close
Set JobsRecSet = Nothing
End Sub

Public Sub CloseConnection()
CConnect.Close
Set CConnect = Nothing
End Sub
I have a form which allows users to Add/Edit Jobs. I have added a Datagrid named dgdJobs and it has 2 columns named "Job Code" and "Job Description". Since I'm using an ODBC connection the Datasource and DataFields for the 2 columns are empty.

I have a procedure that is called with the Jobs Form Activates as follows:

Code:
Private Sub LoadDataGrid()

TimesheetDatabase.Connection
TimesheetDatabase.JobsRecordset

TimesheetDatabase.CloseJobsRecSet
TimesheetDatabase.CloseConnection

End Sub
The part that is missing is how to add the information from the Recordset to the Datagrid.

Thanks

Ferris...

Populating Datagrid Based On Same Field In Database
I have a complicated question, so if i dont explain it properly, or dont supply enough information, please let me know! I have 3 datacombos - 1 for product type and 2 for price Descriptions. for each combo, i wish to populate a column in the datagrid. for the first column, products are populated based on the product type chosen and prices are populated (relating to the products) based on the price descriptions chosen. This would be fine if it was only the product type and 1 of the price combos that i was using but the fact that i am using 2 price descriptions. ( i am using the same fields for comparison purposes). is there anyway i can get around this - my SQL statement isnt working( due to the fact that teh same field is being used twice). do i need to use 2 Adodcs? is it possible to populate a column of the datagrid from a SQL statement? you will see the relationship between the tables here:
Product Type: TypeCode, TypeDescription
Product: ProductCode, ProductDescription, TypeCode
Price: PriceCode, ProductCode, Price
PriceDescription: PriceCode, PriceDesc

Any help would be greatly appreciated!

Using An SQL String To Call Data From Access Database Into VisualBasic DataGrid???..n
the Situtaion:.. I am using an access database that holds dates as strings. example( 06252004 ). I am trying to use an sql string to search everything that is selected from that database table, for dates specified as a start date and end date, which are specified by the user. The results should be placed on a datagrid.

All my sql attempts have failed.

Can anyone help me peice one together, in an SQL string format, that will work in VB and be accepted by access when vb passes it to it?

Importing Microsoft Excel Files Into Microsoft Access Database?
Hello, I was wondering how to automate Microsoft Access to import a Microsoft Excel File? I can do it normally, but I want to know how (or what commands to use) so that my Visual Basic program will create a Microsoft Access database from a Microsoft Excel spreadsheet internally?

Any help will be appreciated - Thanks.

Populating Data From Datagrid 6.0 To Excell Sheet
populating data from datagrid 6.0 to excell sheet ...?

Populating DataGrid W/ Combo Boxes, Like Access Columns
In Access, you can have columns with combo box for the cell. Meaning you would click on a cell and a combo box would appear.

Right now I have information populating a DataGrid in VB but I want to have combo box in a similar fashion to whats in Access. I normally do a search for my question and of course there are hundreds of posts about combo boxes. However, I didn't see a post, or rather a SOLUTION as to how I would do this or if it can be done.

To reiterate, I have a DataGrid which is getting all its information from a table in Access and now I want to click on a cell in the DataGrid and have a combo box appear. Can this be done? If so, how?

Thank you,
Essa

Problem In Populating Data From Datagrid To Excel Sheet
problem in populating data from datagrid to Excel sheet ...?

Access Database Tutorial
Hi, does anyone know where I can get a tutorial on the Access Database? I need to make a program which interacts with a database, read, search, and write to the database. None of the database has to be visible to the user. so I need a tutorial of that sort! Thank you!

Need Complete Tutorial On Access Database With VB6
I need a complete tutorial on using the Microsoft Access Database within a Visual basic 6 application. Or posting the main commands would be helpfull as well.

Populating An Access Database
This may not be the appropriate place for this question, but as I am doing this in VB6...

I've heard mention of people using a third-party app to fill in the fields of an Access database.

Does anyone happen to know these apps and where I can get them?

Populating VB List From Access Database
I have been trying for days to work out how to do the following and i still haven't got a clue how to do it.

I have on Drive C: an Access database named SKM_ICE Dbase.mbd with various Tables, one of which is named tbl_Master, in this table are fields OurRef, Payment Received and Insurance Co.

In my Visual Basic Application i have a Form named frmForm1 which has on it a ComboBox (listing Insurance companies) and a Command button.

Now for the hard bit ...... When the command button is clicked i need to display in a list on Form1 the entries from the database which match the Insurance Company in the combobox where the database field Payment Received = NO

I have no idea how to do this or what type of list or grid or whatever to display the results in.

Your help will be appreciated.

Populating A Combo Box From An Access Database
Hi all,
I am trying to populate a combo box from an Access database using VB6, Access 97 and the data control. No records will appear in the combo box at all. Any help would be appreciated.
Thanks, Sandy

[VB6] Populating A String With Data From A Database
Hi, after some effort i've managed to connect to a JET (Access) Database using ADO in VB6, but i dont know how to store information retrieved from it in a string. I want to be able to store data from each field in the currently selected row in a predefined string.

Flat-File Database, consisting of three fields "UserID" (autonumber) "Username" (text) and "Password" (text)

Populating A Textbox With Data From A Database
Hey,
I'm using ASP.NET linked to Sql Server and I need to have an edit form for a project I'm working on.
I want to be able to link the textbox.text to fields from the database. In other words when the page loads, the text boxes will be filled in using the data from my database and the user can just edit whichever fields they need. I dont know if this possible or not cause I havent worked with VB for that long. I know that theres an edititable datagrid but this isnt suitable for the application.
I'd appreciate any help
Thanks

Populating Table Located In Another Access Database
I have created a table in an Access database from an XML document (db1.table1). Now I want to grab data from a different Access database table (db2.table2) to populate the table created from the XML document (db1.table1).

Basically, I want to populate a table with data that is located in another table in another database.

How do I do this?

Edited by - bgreen on 11/12/2002 10:05:32 AM

Populating The Grid With Data Coming From Database And A Variable Which Increments
im planning to get the data from the database and from a variable that increments...

i dont know how will i be able to display this on the flexgrid..

No name title

1 cathy Accountant

cathy and accountant will cum from the database and no .. would be from
no = no + 1

Populating Excel Spreadsheet With Access DB Data
Greetings,

We need to populate some cells of an Excel spreadsheet with data from an
Access db which users access through a VB6 application. We want application
users to be able to accomplish the data transfer from Access to Excel, and
then print the spreadsheet, all through the VB application.

Can anyone please point me to the proper documentation concerning the issues
here, or possibly even provide some relevant VB6 code samples? Thankfully
yours...

Ralph D. Lynch

Can You Use An HTML Form To Access A Microsoft Access Database?
Can you use an HTML form to access a Microsoft Access Database?

Populating Data From A Text File To Access Table
Please help: I need to create a table that contains data from a flat file;there is one file for each machine on
our domain. The file called "feedback.fbk" exist in a folder, on a server. There is a folder named for each
machine. An example of the path is:

\serverXdir1dir2dir3dir4folder named after each machinefeedback.fbk.

- The routine should end when the entry after the first comma changes.
- The entry after the third comma is the column header
- The entry after the fifth comma is the value for the column header.

Thanks a million. I'm old to Access, but new to modules.

The contents of the file is pasted for your reference:

10001,00001,20010820090547,Physical RAM (total),,133615616,1
10001,00002,20010820090547,Physical RAM (free),,39948288,1
10001,00003,20010820090547,Page file (total),,266870784,1
10001,00004,20010820090547,Page file (free),,182407168,1
10001,00005,20010820090547,Memory load (%),,0,15
10002,00001,20010820090547,Screen Dimension,,800x600,14
10002,00002,20010820090547,Display Adapter,,ATI 3D Compatible Graphics Adapter,0
10003,00010,20010820090547,Size C: (KBytes),C:,8224768,2
10003,00011,20010820090547,Free C: (KBytes),C:,3122688,2
10003,000010,20010820090547,Size D: (KBytes),D:,8224768,2
10003,000011,20010820090547,Free D: (KBytes),D:,3122688,2
10004,00002,20010820090547,Mousebuttons swapped,,no,16
10004,00001,20010820090547,Keyboard Layout,,US,16
10005,00004,20010820090547,TCP/IP Address(es),,222.155.225.128,16
10005,00003,20010820090547,MAC Address,,BDAA2D3E55AB,16
10005,00002,20010820090547,Network Adapter,,Intel(R) PRO/100+ Management Adapter with Alert on
LAN* [Bus 0 Slot 18],16
10007,00001,20010820090547,Processor,, Pentium,16
10007,00007,20010820090547,Processor Version,,Level 6 Rev. 5.2,16
10007,00008,20010820090547,No of Processors,,1,16
10007,00002,20010820090547,Processor Speed (Mhz),,448,16
10007,00003,20010820090547,BIOS Vendor,,,16
10007,00004,20010820090547,BIOS Date,,08/22/99,16
10008,00001,20010820090547,OS,,Windows NT,0
10008,00002,20010820090547,Version,,4.0 (1381.Service Pack 6),0
10008,00006,20010820090547,System Language ID,,$0409,0
10008,00009,20010820090547,Registered Owner,,PC-USER,0
10008,00010,20010820090547,Registered Organization,,Company x AG,0
10008,00011,20010820090547,Product Serial Number,,50036270696073425873,0
10010,00001,20010820090547,Default Printer,,n/a,14
20001,00001,20010820090547,Client Version,,3.5v22 SP5,0
20001,00002,20010820090547,Date/Time of data feedback,,8/20/01 9:05:47 AM,0
30000,00000,20010820090542,{00007CDP}{Win32}{US}{1}{0},,Client Distribution
Package,{00007CDP}{Win32}{US}{1}{0},19991129134608

Printing A List Box After Populating It With Data From An Access Table
I cannot find the syntax for the printing of a list box that has been populated with data from an access table.

Populating An Excel Worksheet Embedded In An Access Report With Data
IS IT POSSIBLE TO MANIPULATE DATA INSIDE AN EXCEL WORKSHEET THAT IS EMBEDDED IN AN ACCESS REPORT??? I'm beginning to think not. I've been trying for 2 days with no success.

I inserted worksheets in various ways, but let's say I insert a worksheet by doing the following:

In report design mode --> Insert --> Object... --> Create New --> Microsoft Excel Worksheet.

Now, I have a query. I want to populate the embedded, or linked, excel worksheet with the results of my query.

Access cannot create diagonal column headers which my client REQUIRES, and the "Rotate Text" ActiveX control is not clean enough. So, I am using an Excel worksheet for the formatting only. I would import data into the Excel Worksheet from Excel rather than Access, but unfortunately, since my query is a complex crosstab query with a parameter, I get errors when I try to write the SQL statement in Excel. Therefore, I need to embed the worksheet in my Access Report and populate it with data programatically. So far, all my attempts have failed.

At this point I've removed all the unnecessary complexity and all I have is this:

1 Table with two columns (id, name)
1 Query getting names from the table
1 Report with an embedded Microsoft Excel Worksheet

Can somebody please tell me how to get the names into the worksheet in the report?

Microsoft Access Database
I have program where the database store as table in Microsoft Access database.

If I do package and deployment Wizard, Does I have to copy the Microsoft Access database that contains password table to target machine or it also include during package and deployment Wizard ?

Does Client Machine need to be install Mircosoft Access software?

Microsoft Access Database In Vb 6
HI,
How do you connect to a database then read/write to it?
Many Thanx
jjohall2000

Microsoft Access Database
In my application I use Microsoft Access database.
I want users to access this database using my application.
But I don’t want users to access the database

What are the available methods to do this …

Can ASP && VB6.0 Access Microsoft Access Database At The Same Time?
I am a student currently doing a project that took about eight months. Currently, I am facing a big problem concerning Microsoft Access database. My project is due in the end of this June month.

I am developing an application called Library System that uses Visual Basic 6.0 as the program that handles borrow & return, extension of borrow date, reservation of books...etc and another web application ASP that handles Reservation and checking book status. The database in use is Microsoft Access 2000 which resides on the machine where the Visual Basic built program is used.

My problem is that when I opened the Visual Basic application, I can't use the ASP. I get the error:

"file in use"

in the ASP error page since both VB6.0 and ASP are accessing the Microsoft Access at the same time.

My question is can I get both applications (Visual Basic 6.0 & ASP) to be able to access the Ms. Access 2000 database at the same time? Please, I am VERY DESPERATE. My project is to be submitted soon.

SQL In VB6.0 For Accesing Microsoft Access Database
Can you please take a look at the code below and tell me what is wrong:

demand = "SELECT [Tabelle Kundenanschriften nach KD Nr].[Kunde] "
demand = demand + " FROM [Tabelle Kundenanschriften nach KD Nr] "
demand = demand + " WHERE ([Projekt].[Datum Bestellung]>= #" + FirstDate.Value + "#) AND "
demand = demand + " ([Projekt].[Datum Bestellung]<= #" + SecondDate.Value + "#)"

I think my error is when comparing dates (row 3 and 4). And another question: I work with two tables connected through a field customerID. Do I need to put the condition that the customerID in one table to be the same as in the other table or this is done automaticaly?

Sharing A Microsoft Access Database
Hi,

I have just finished my first database application using VB6 and Microsoft Access 2000.

I have a major problem. I placed the complete program on the File Server. My Application is called "Autohouse Solution". I have a M: mapped on all machines to the server.

When I run the application as standalone, it runs fine.

When i add a record it appears on the customers list as usual.

Today, I ran a test with the application. I opened the application on 2 machines - Machine1 (user1) and Machine2 (user2).

User1 opens the customers form list. And User2 opens the customers form list.

When User1 adds customer it is not displayed as expected, however the list is not displayed on customer2 when he clicks refresh. Both applications are pointing to the same database. And am refreshing the recordset.

I closed the customers form on both machines and re-open them. Still only the new customer appears only on User1 (the one who added the customer) but not on machine2.

Someone told me this was because I have to compile the MDB as an MDE file in order to be sharable. Why is this happening?

The amazing thing was that the database did not contain the new customer record I added, however it displayed on Machine 1 and Not machine2. What is happening???

This application is due tommorrow! Please Help my programming career before it turns into a nightmare!!

Microsoft Access Database On CD Problem
I made one program that converts a large text file into MS ACCESS format (97) mode 4. I have another program that is to open the access file and bind a text box and rich text box to the data.

This program works fine when it's on a writeable filesystem. When I copy the executable and mdb file to the cd- It can't open it.

I get the following error. Microsoft Jet Engine cannot open the file f:purge.mdb, It is already opened exclusively or you need permission to view the data.

How can I open a database on a cd without getting that error since it's a read only filesystem?

Jeremy

Microsoft Access - Vb Database Problem
I made a "very" simple database using Microsoft Access 2000. Then I add a data control in my vb form.....in the "database name", I put the source for the database I created, and then I go to the "record source", and when I click on the arrow, to add a record, I get an error message saying "Unrecognizable database format".
This only happens with the databases I create..all the other databases (biblio.mdb, and others that I have downloaded) work fine. Does anyone know why this happens?

I have included the database with this post, if this will help anyone (only about 8 Kb).......Thanks

Microsoft Access Database Limitation
Hi There
I am using Visual Basic 6.0 and Microsoft Access 2003 to develop systems. My problem is that the access database file has a maximum capacity of 2Gig (Minus database objects). My clients are complaining because of this problem. I'm in need of an solution. If anyone has information regarding this problem, even if it means moving from access DBMS, please feel free to provide me with this information. Thanx in advance.

HELP - Microsoft Access Database Size
ITtoolbox Portal for Visual Basic - http://visualbasic.ittoolbox.com/

I currently have a number of Access97 databases being used in adepartment which are to say the least becoming big and wobbly.

The database operations stop when the size reaches 1 Gig, (Accessreports database has reached maximum size) is there anyway of stoppingthis, and letting access over run this size limit?

The data is stripped off regularly, as some of the tables contain 2million + records, but unfortunately i have inheirited the problems of aprevious database killer (Sorry i mean programmer).
We are currently in the process of migrating to SQL but because of costsetc. this isnt going to happen quickly, so in the meantime I need helpquickly.

Regards
Steve Tempest

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~

Query Microsoft Access DataBase
hi, all

i need help to create a simple and faster query because the data more thn 1
million record, and i must re-check each record cause they need to encode
first before i can use them.

now, for example we have a database that contain 3 field :

MainNumber as AutoNumber

MainDelete as number

CustName as string

Field MainDelete is contains a number that not use anymore for further, nd
that number is taken from field MainNumber.

MainNumber MainDelete Custname

1 0 Alex

2 0 Cynthia

3 2 Christpher

4 0 Fransisca

.... .... ....

Now, i need a query that can grab all data, where the mainnumber is not n
Main Delete, so only 1, 3 and 4.

The data 2, is not include in query cause he already exist on Maindelete

is That Possible to create a query like it ????

Please Help Me.

Thanks Before,

Hok Sun

Problem With Accessing A Microsoft Access Database Is VB 6.0
Hello, I'm sorry for asking such a dumb question as this since I'm sure u guys are all professional programmers, but I'm a newbie in VB .
What I've been trying to do is make a list of my books in Access with the following record subjects: Book Title, Issue Title, Publisher, ISBN number, Volume Number and Author.
In my VB project, I made those 6 text fields, so that later on I can add, delete, modify or do whatever I need to the list of books. Then I cliccked the "Data" icon in the Toolbox to add the data thingy on my form.

This is the part where I got stuck: after changing the properties of the Data object (like changing the path to the DatabaseName to C:whatevermangalist.mdb), I tried to run the program so far, but it tells me "Unrecognized Database Format"

How can I fix the problem? I was thinking that it might have to do with a problem in the Database itself?....Any suggestions?
Thnx!

Deleting Records From A Database (Microsoft Access)
Hi ive created a program to store movie names and their categories. Ive used a recordset to connect to the database from vb6 but i am having trouble deleting a record from the database from vb6.
If there is any other information you wish to know then please ask but if anyone knows an effective method to delete records from a databse or knows a website that would be of any help please post it.
Thanks

Load A Microsoft Access Database Into A Treeview
Hi all,

I'm a little stuck with this problem of how to load a database(I'm working with a simple database in Access that has the infgrmation of names and addresses from an address book) into a treeview control. I'm using ADO in VB6 as i prefer this over DAO. What i'm trying to acheive is having a treeview control on a form that may show the persons last name, and then by clicking on the item can reveal more information?

Thanks in advance
Jason

Microsoft Access 2000 Database Crash
Hi gurus,

OS:Windows 2000 SP 4.0
D/b:Office 2000

I have a Access db which was working fine for 5 yrs on a standalone m/c

Now recently, we've upgraded to work on network.

Now, this d/b is operated by 3 persons.

Now the problem is, the database is getting corrupted every now & often.
But, Repairing the d/b would solve the problem. But for that all the three users have to close their application. One of the user will repair it. and then others start the application.

But this is happening very often. Even when 2 users are not operating, but their applications are open also, the third computer makes the d/b corrupt.

The client wants it on Access backend. This is my problem.

How can I solve this.
What's the solution?

Please help me out.

With Regards,
Shivakumar G.M.

How To Use An Encrypted Microsoft Access Database In VB Program
how to use an encrypted microsoft access database in VB program. if i encrypt it, the VB program is not able to access it through DAO method. if i leave it unencrypted, anyone can modify it.
pl help

Microsoft Installer Tutorial
Is there a quick MS installer tutorial outthere?

Thanks in advance

Populating Selected Records From Access Data Base To Excel Sheet Using Sql Querie Through Application
populating selected records from access data base to Excel sheet using Sql querie through application ...?

How To Export Dbase (*.dbf) File To Microsoft Access Database
I want to export Dbase file (*.dbf) to Microsoft Access database through Visual Basic. Is there any way that i can open Dbase file in a shared mode through Visual Basic

Installing Database Programs On Machines Without Microsoft Access
I have a program in VB 6 that uses an access database.
When using Visual studio installer, the file msacc8.olb generates a message that "neither a merge module or dependency info could be found for msacc8.olb"
The program just uses the database and I hope to be able to install it on machines that do not have Microsoft Access.
The User will not have to work with the database as code handles all the connections.
What I'm wondering is, if there are other files which VB didn't add to the project that I would need to create a merge module for to get the program to work correctly in such a case.
Obviously, I have Access so it's going to work fine for me. I'd prefer not to have to uninstall it to find out.
I'm a newbie and self taught so really technical stuff will go right over my head.
TIA for any suggestions
Tim Garrison

How To Use EVB Code To Download Microsoft Access Database To Pocket PC ?
Hi,

I have a Microsoft Access database and I use eVB to develop my application. My problem is how to download my database to Pocket PC ?
There are several sites talking about functionality of Microsoft Active Sync ("Import Database Tables") which I found not so friendly.

I am trying to use vb function which is DestoptoDevice function but it cannot be use in Pocket Pc because the vb function that I use is not in Pocket PC environment.
Even I use SHELL in evb to call the vb exe file, it still not work !!!

So I need someone who have experience it to suggest to me...which I want to use evb coding / function to download my Microsoft Access database to my Pocket PC (.cdb) database.

Meanwhile I can't find any solution. ..so I hope someone got an idea for it

Thanks you

Justina

Tutorial On Populating A DataGrid With Data From A Microsoft Access Database

can someone plz tell me how to do this or give me a link to a tutoriali have been searching the net and this forum for ages and aint been able to find a simple tutorial that explains how to simply add data from an access database to a datagrid on my VB 6 form

can someone plz tell me how to do this or give me a link to a tutorial

i have been searching the net and this forum for ages and aint been able to find a simple tutorial that explains how to simply add data from an access database to a datagrid on my VB 6 form