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
Printable View
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
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.