specifying the database to query

Okay, this may sound ignorant, but I'm having a prob getting my VB project to recognize the Access database as where all SQL queries are to hit. Everything I've read in Help & Mastering VB 6.0 shows sample code of client side applications hitting a SQL DB on a server somewhere. My Access database is on the same computer where the VB project stays. How do I define this database (only one table) as the source for the one SQL query string in my code?

[Serge]

You can use DAO object library. Add a reference to Microsoft DAO library 3.51 (or select the highest version you have installed on your computer). Also, add a listbox to your form. Then you can use this code:

Dim db As Database
Dim rs As Recordset

Set db = Workspaces(0).OpenDatabase("C:\MyDB.mdb") 'Change this to appropriate path
Set rs = db.OpenRecordset("MyTable", dbopenTable)
Do Until rs.EOF
    List1.AddItem rs("Name")
    rs.MoveNext
Loop

Assuming that I have a table called MyTable and a field in that table called Name.

------------------

Serge

Software Developer
[email protected]
[email protected]
ICQ#: 51055819



[This message has been edited by Serge (edited 12-14-1999).]

[Gimpster]

I don't know a whole lot about Access databases, but do they accept SQL statements? Or do they have their own set of codes? You might look into that.

------------------
Ryan
[email protected]
ICQ# 47799046


[This message has been edited by Gimpster (edited 12-15-1999).]

[JHausmann]

Yes, Access accepts SQL.