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
sydneyguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
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
0
sydneyguyAuthor Commented:
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
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
I am not a c++ expert (would like to be though) but I certainly know Access!

here are a couple links that will help get you on your way:

https://msdn.microsoft.com/en-us/library/cc811599%28v=office.12%29.aspx?f=255&MSPPError=-2147217396

https://msdn.microsoft.com/en-us/library/7wtdsdkh.aspx

Perhaps if you have questions, I can help you with the Access part ~ just post back here and I will do my best to understand your code and interject Access logic

I will also keep an eye on this thread and hopefully someone more knowledgeable than myself will jump in and we can both learn ~
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sarabandeCommented:
you may consider to add a 'datasource' in windows for your access db. use the odbcad32.exe or odbc applet from system settings.

then, in an mfc application you could use the class wizard to connect to the database and create new classes derived from CDatabase and CRecordset for each table you want to access. those classes provide basic sql functionality like select, update, insert, delete.

note, ms has a few sample projects for recordset and database classes.

Sara
0
sydneyguyAuthor Commented:
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
0
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help

warm regards,
crystal

~ have an awesome day ~
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C++

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.