Compiler not recognizing DAO object

[ahmadbaseet]

Hello every one. I am new to MS Access. I am using data SQL command SELECT to fetch some data from Access tables. I want to use DAO.Recordset object to get the data, but somehow my compiler is not recognizing the DAO object. I am using Access 2003. Can somebody help me. I cannot declare Dim rs As DAO. Thanks in advance

[missinglinq]

Is the Microsoft DAO 3.6 Object Library set in references?
(Tools - References)
Then
Dim db As DAO.Database
Dim rs As DAO.Recordset

Linq ;0)>

[ahmadbaseet]

Hello, Can u please tell me how to set it?.Actually Whan I write Dim rs As, and then press space, the list comes in which all the classes are their, for example, String etc. But DAO is not their. I saw on my friends computer. it was their in Access 2003. As said I am new to Access. Thanks. Plz explain it if u can.. Very thanks in advance

[ahmadbaseet]

Actually I am doing something like that

Dim rst as DAO.recordset

set rst = currentdb.openrecordset("SELECT Atty_TK,Client,Matter,Description FROM qry_LastJob")

if not rst.bof and not rst.eof then

Me.cmbo_atty = rst("Atty_TK")
Me.cmbo_Client = rst("Client")
Me.cmbo_matter = rst("Matter")
Me.Description = rst("Description")
end if

[missinglinq]

To set the reference go into the VBA code editor from Design View for any form, then goto Tools - References and scroll wayyyyyyyyyy down until you get to Microsoft DAO 3.6 Object Library. Check it and click on OK and you should be set!

Linq ;0)>

[ahmadbaseet]

Ahhh.. ok.....Very very thanks.... Sorry about my English..

[ahmadbaseet]

One more problem, I have two table which are connected thru one to many relationship. I am entering data in the main table with sql command. But getting Error Kay voilation error. I set one field as a primary key. Why am I getting KEY VOILATION error. Thanx