what is benefit to convert from text database to access?

[Malkiat]

I am trying to make a program in vb, which converts the access database in
text files with a '^' sign in fields. I looking for any other benefit related
to conversion of text database in acees (so that we can refer primary r
secondary keys in vb coding o contact all the database tables). Is it right
that we can assign reference keys for tables in Access in visual basic
coding. Please let me know...i really need to know about this topic..

 

[John Nurick]

Hi Malkiat,

The advantages of storing data in Access tables rather than text files
include the following. For more information search in Access help or on
the internet:

- Tables can easily be indexed, which makes finding data much faster and
can protect against duplicate data.
- It is possible to establish relational integrity between tables, which
helps protect your data against inconsistency.
- Records can easily be edited (Access cannot edit records in most text
files).
- It is easy to alter the structure of an table (for instance to add an
Autonumber field to use as a key)