Solved

Holding Information

Posted on 2002-07-17
6
189 Views
Last Modified: 2010-05-02
I am looking for a way to save information.  I want to create a database like information center in Visual Basic or C++ (preferrably VB) without actually using a database.  My concerns:

1) Size of the saved file
2) Information access speed

What is the most efficient way to do this.

I guess my question is for example, how does Excel hold information in a file and then read it quickly when opening the files?
0
Comment
Question by:cruzer330
6 Comments
 
LVL 32

Expert Comment

by:bhess1
ID: 7159916
Your design will depend on what type of information you want to retain, and how much information.

Will your data be in 'Records' (with fixed maximum size fields), or will it be free-form

Will you have 100 or less records, 1,000,000 records, or somewhere in between?

Will the user be designing the data layouts, or will they be fixed by the program?

Before knowing at least this, there is really no way for anyone to answer this question.
0
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 100 total points
ID: 7159944
why do you not want to "actually use a database".  VB can create an Access Database EVEN IF YOU DO NOT OWN a copy of Access.

Arthur Wood
0
 

Author Comment

by:cruzer330
ID: 7160281
bhess1:  There will be information records ranging starting with 1000 records and upwards.  The fields and types will be fixed type and amount.

Arthur Wood: Interesting.  But I want to make sure that my distribution copy is not too large either. Please explain a little of your method.

Say for example, baseball player information.  First name, Last Name would be a text field and so on.  At-bats, hits, strikeouts would be a number field and so on.  I would like to sort on different fields.  Also hold names in one "recordset" and daily stats matched with a unique record in another.  In addition, I would like quick ways to total the daily stats and come up with monthly/seasonal information.  Am I asking too much?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 4

Expert Comment

by:AlonHirsch
ID: 7161384
As Arthur suggest - you do not need Access in order to create an access database, or any of the other supported database formats either (DBF etc.).
I would recommend using an Access type database - it's simple and works very well from within VB.

Using VB6 - simply choose 'Visual Data Manager' from the 'Add-Ins' menu, and you will be presented with a VB program for creating Access '97 type databases.

If you would prefer to use an Access 2000 database, you can create it using Access 2000 (if you have it) or via code using ADOX. Simply search the help files for ADOX.

HTH,
Alon
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 8013827
Hi cruzer330,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept Arthur_Wood@devx's comment(s) as an answer.

cruzer330, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Computer101
ID: 8096079
Comment from expert accepted as answer

Computer101
E-E Admin
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Using "ScreenUpdating" 6 63
using web browser with BING 40 119
Can we place a tooltip on the actual vb6 form 5 41
IF ELSE Statement in Excel Macro VBA 16 63
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question