stewartbrown
asked on
Using VB To read an Access (*MDB) file...how?
Can some one write me up a simple demo of how you can access an MS Acces database file from within VB.. i want to be able to read and write to and from it. is there a way to find the field names too? i want to be able to do this without having MS Access installed..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
c4Mar:
You may want to review your "Answer" as there are several (typing?) errors there.. <smile>.
You may want to review your "Answer" as there are several (typing?) errors there.. <smile>.
ASKER
Adjusted points from 50 to 150 (excellent Answer!)
ASKER
Excellent! :) i'll award you the points soon, i'm just going to keep the question open.. so that i don't "lose" you(r help)... i plan on asking a few more questions.. :) heh heh.. I'll up the points as i ask.. then you can have them all.. unless you wish to have them as separate questions...
Stewartbrown, I think it would perhaps be better if you were to post seperate questions. You may have a question the answer to which may benefit other people, they would not then be able to find it as it will be buried under your original title.
ASKER
Thank you for the wonderful example code! :) i'm going to post another question.. dealing with your code after i accept this comment as an answer.. so please look for it wsh2, and see what you think... Thanks again..
Dim wa as workplace
Dim db as database
dim rs as recordset
..
..
..
..
..
set ws = workspace(0)
set de ws.openDatabase("database name")
set rs = db.openrecordset("SQL code in here")
once you open a recordset , u can use rs.addnew, rs.update such command to update or change the database information. However, if u want to read specifier field, you would need to use
such thing like
rs.field("client_ID") to read the data.