Link to home
Start Free TrialLog in
Avatar of sydneyguy
sydneyguyFlag for Australia

asked on

c++ msaccess db access preferably not going though a from

Hi i am looking for a good example on how to access a MSaccess db say 2003 , i will be movig that to sql server down the track but have a db set up in access and just need some code an how to do it, a sample would be nice to get me started but if not code would do me fine, am looking around so any help would be great
actually after code that does not rquire going through a form
thanks for  your help
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Can you explain a little more what you want right now?

what do you want to do? Get to tables? The user interface stuff?

Do you just want to get to know Access a little better?

thanks
Avatar of sydneyguy

ASKER

Hi crystal
i need to from c++ to access the data from a msaccess 2003 data base and extract the data from two tables or one query where i will be placing the data into a c++ treeview container.
so i am after the code to all
1) access the db msaccess 2003 from c++
2) extract the data out of some sql query using sql statements in c++
now i have access to the data in some sort of object
3) once i have access to that level i can then manipulate the data to how i want it
ASKER CERTIFIED SOLUTION
Avatar of crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks for you help have got acccss to the database  now i need to get the data into an array but will post this as a new question
you're welcome ~ happy to help

warm regards,
crystal

~ have an awesome day ~