Link to home
Start Free TrialLog in
Avatar of skibud2
skibud2

asked on

database format

I have a program that needs to access a table of values. I would like to store this table in an external database. What format should I use. The table consists of about 130 rows x 3 columns. Each entry is a string that can contain ('+'/'-' and alph-numerics). I do not want this file to be easily read by users (ie I don't want it to be able to be read with a simple text editor). I don't mind if the file can be read by Access or a similar program. Any suggestions would be much appreciated. Please inform me reasons for your suggestions. I am currently programming in VS 6 enterprise.
Avatar of vk1981
vk1981

I use MySql. It's very cool...
Avatar of skibud2

ASKER

MySql is not quite what I am looking for. I use MySql with my php apps and it is very nice. It is not something that I would ship to customers. I was debating about using an access database or dbase file and using the CDaoDatabase class.
Hi!
You can use ADO objects to maintain database
this solution require install extra components: ms_dactyp.exe - MS Data Access Components to the user machine.
For that small amount of data you can put it handily in a Microsoft Document (Document Architecture).  

- your users won't need a database
- not easily read/used by other applications
- easy to implement

~ create a row class that has three variables (CString) for each column

~ put all the rows in a CObArray

~ write the serialization routine(s)

good luck - christophm
Avatar of skibud2

ASKER

christophm,

Do you mind providing a simple CObject derived class for the rows. For some reason, I cannot get the SerializeElements to work.
Hi skibud2,
I am working on a long note for you.  But, in the meantime --  your classes must inherit from CObject to be serializable.  cm
ASKER CERTIFIED SOLUTION
Avatar of christophm
christophm

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