access Table C++
Posted on 2008-06-13
My company uses a database that uses a fixed lenght dat file for its tables. Me and another programmer who is not here anymore worked out a way to pull the data into access and also into msSQL. this works out great, i know vba and sql pretty well so no problems. every month, for billing porposes we have to update the parts costs in one of the tables. The new parts cost are listed in another program that is updated and distributed to everyone that uses it month. It uses propriety table structures and files and such but also had tools built into it for programmers to access the data through C++ and VB. THis worked out great because we knew vb and was fast, we could update 53 thousand parts in about 5 minutes or so.
Now though, the parts program is coded by another company and they have ripped out all vb compatibilty and only uses c++ which i barely knew 8 years ago. now i know nothing. I know you can integrate vb.net and c++.net but all of our program coding, which is extensive by now is done in access really. we have a distributed adp which grants access to reports, table, querys and such.
My question is, is there a way to get c++ to read an access table into an array or something. once in the array i can loop through it and get the new parts cost using the tool provided. i would rather not have to work on moving to vb.net out of our adp because we have been expanding/improving it for 4 years now and it is rather large. I dont know vb.net and have started to learn it some but its just not clicking in my head yet.