My knowledge is lacking in one major area of programming --Databases.
I need a database to record data over say a month or so and need to be able to view trends in the data. It needs to have no external maintanance, everything has to be handled in program, and I doubt this system will have Excel(although it might). I'm guessing that it will have to be Random Access, it just makes life easier to start in the middle of a data set.
So... How should I go about implementing something like this? Once I get the idea down, I'll probably throw the database code into a class for code reuse. (or maybe an activeX control.)
Basically the users of the program shouldn't know about the database at all except that they can view the data produced from it. The data will be used to help localize trends and diagnose problems with equipment, etc.
- Dim A
