Solved

software developmaent

Posted on 2000-02-23
2
131 Views
Last Modified: 2010-05-02
when we are developing software in visual basic is it good to develope the database files using access or random file handdling  ?
0
Comment
Question by:nilesh
2 Comments
 
LVL 3

Expert Comment

by:paulstamp
ID: 2553505
Depends entirely upon the nature of your data and your application.

For large amounts of structured data use a proper DB system like Access/SQL Server/Oracle.

If you dont have that much data you can use random file access - it doesnt have the overhead of the very large DLLs that database access require.
0
 

Accepted Solution

by:
smartpad earned 10 total points
ID: 2593119
It is best to use a database to store large amounts of data. This will allow the system to query the records faster that using a file system. It also allows for indexes and data validation that ould otherwise have to be done on the client side.

0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

762 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now