This thread is for discussions of DAO 3.6 Library.

Good explanation, although I must point a few things:

1.  To delete all records from a database, going 1 by 1 can be a very time-consuming procedure.  Instead, you should consider using a Delete SQL statement.
2.  The ChangeField function can become repetitive:  What if I have to change several fields.  You could consider using ParamArray for the parameters of the ChangeField function so you can update more than one field at once.
3.  There is no need (that I know of) to open a table using SQL if you're not using where or order by or that sort of stuff.  You can open the table directly using the table name (query names too) in the call to openrecordset.  Also, you should always specify the cursor type, as some people might expect one type but could get another.  I think the default is snapshot?  Dynaset cursors are best, if you don't have a problem with resources.
4.  The AddNewrecord function can take a long time to run?
5.  You use the integer data type for handling ID's, but you should use Long data types because ID's can go beyond 32767, the upper limit of a integer value in VB.

Thanks webjose... Some very good points. I shall revise this article when I have finished my exams to include your points. Thanks again.

I refresh back that when I delete a recordset in database. if the few row of the data same all GONE.....

to start using DAO...i find it better since it allows you the familiar "object-property" programming style.

What is the code for moving to a record using the ID field.  For example, I was to display information for the record with the ID 3.  What code would move to the record with the ID 3.  I know everything else I need. Thanks.

hello!
I didn't get how can i view information from the database and how can i check it... i mean let's say i have login page, so i write:
Code:

if UCase$(txtLogin.text) = LoginInDataBase then ...

what should i put instead of LoginInDataBase

PLEASE HELP!!! i gotta hand in my project soon!!!

...error message. All I get is Error message: *User-defined type not defined* when I try to run this example.   Any thoughts?

bruwmac

The functions referenced in the example require the DAO3.6 library. To access this library you need to :

a. Go to Tools->References in your VB Editor
b. Locate "Microsoft  DAO 3.6 Object Library" and check the box next to it.

If you do not find it, you can click the Browse button to search for [C/D/E]:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll.

 Thanks much. Happy New Year.

I just started my first database project, and this article helped me understand alot of the basics involved with DB programming.  I would just like to say thanks first.

Now, to the point.  I am using a Database created in access 2000, with 3 tables.  Whenever the program tries to bind the DB variable to the database, I keep getting an error that says:

RunTime Error:'3423'

You cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM database table to your database.

Can you please explain why it's doing this, and what I have to do to fix this?

You can access an id field using the data control:
data1.recordeset.findfirst ("ID=3") assuming ID to be a field in the recordset.
I would like to know if you can use a variable instead of a value - can't find the correct syntax.

i planning to do a database

actually i found out that this method would be easier but i dont know how to do it!

this is what i want.
im developing a user-login-database

1. when a user logs in.. the tables for his id should be displayed.

let me make it simple :when a new user is added to the existing table (tblUserList)

2. another table(tlb*userID*Detail) should be created using the UserId as the table name
  (including the fields like FirstName, MidName,LastName and so on) automaticly when
  the New user id is added to table tblUserList.

i think i can do the part (1) if you guys can help me with the part (2).

Id like to help you. I think I could but im to to sure what you mean?
Do you want A table to be created for each separet user ? If so why and maby I can give you a solution?

sascha

It could be quit a lot of things. First I would check my connection string.
I wants had some error when working with access. The reason was that the acces database was desighn in a newer ver. then to the one i had on the computer. Im not sure if that will help you?
To check connection string try using the adodc control to make a connection to your DB if that works copy and past the connection string into your code check if it is the same.

hope that helps..

sascha