Connect Data Control to Access 97 secured DB via MDW file ..

Re VB 6.0 & Access 97
I am using the MS Data Control on a form which I need to refresh each time
the user enters criteria. The DB is secured via an MDW file.

Could someone please provide an example, using DAO, with a solution to
connect the Data Control to an 'ever changing' dataset, returned from this
secured DB - assuming this is possible.

Many thanks.

Sussed it with the following;

DBEngine.SystemDB = "<Path to mdw file>"

Set ws = CreateWorkspace("", "Username", "Password", dbUseJet)

Set db = ws.OpenDatabase("<Path to mdb file>")

Set rs = db.OpenRecordset("SELECT ...")

Set Data1.Recordset = rs

Pete

> Re VB 6.0 & Access 97
> I am using the MS Data Control on a form which I need to refresh each time
> the user enters criteria. The DB is secured via an MDW file.
>
> Could someone please provide an example, using DAO, with a solution to
> connect the Data Control to an 'ever changing' dataset, returned from this
> secured DB - assuming this is possible.
>
> Many thanks.