Database and vb6

[MIB357]

ok here is what i want to do is to be able to write to a mdb file how can i go about doind this with in my database app
thanks

[Vit]

There are several ways to access .mdb file. The most convenient is using DAO.

Add reference to MS DAO 3.xx to your project

Add the following into your declarations secton

Dim db as database
Dim rs as recordset

Here's the code to open database

Set db= opendatabase("yourFileName")
set rs = db.openrecordset("Select ListOfFields From TableName Where ... Order by ...", dbOpenDynaset (or table or snapshot)

Now the data you need is entered into recordset.

If you have any problems, see VB help.