Re: Database Stuff

Tech-Archive recommends: Fix windows errors by optimizing your registry




"Mike Williams" <mikea@xxxxxxxxxxxxxxxxx> wrote in message
news:Ou8c4scqIHA.3616@xxxxxxxxxxxxxxxxxxxxxxx
Being a hobbyist and writing mostly stand alone utilities for myself and
friends I have always "rolled my own" database structures (using various
methods including fixed size records and / or various linking arrangements
for variable sized records) and they have always previously suited my
purposes, being just about as fast as anything you can get but, of course,
being specific to my own particular stand alone application and being
unsuitable for read and write access by more than one person at a time.

Now my daughter has asked if I can write something for her which performs
the sort of tasks and creates the sort of displays that I've always done
before, but which can be used by a number of separate people on a number
of separate machines such that each person is accessing the same database
at the same time for both read and write operations and, if necessary, for
the creation of new records. I'm fairly sure that given enough time I
could come up with my own "home brewed" data structure and controlling
code which would allow such a thing, but even after just a very short
consideration I can already see lots and lots of hurdles that I would be
required to jump and, of course, I don't want to reinvent the wheel.

Also, it would be nice if the main database was in a standard format so
that it could, if necessary, also be read by other applications (although
that is not an essential requirement). I don't want to use Access or
anything similar because I want my application to run on machines where
Access will probably not be installed. I have never actually dipped my
toes into this client / server corporate database water before (if that's
what it's called) and I would really appreciate it if anyone could give me
any tips / pointers and any general "outline explanations" or perhaps even
provide some links to any suitable tutorials which are VB6 specific?

Mike


Check out SQLite as well. There are plenty of VB interfaces for it that a
quick google search will turn up.

www.sqlite.org

HTH

Matt


.



Relevant Pages

  • Re: Database Stuff
    ... friends I have always "rolled my own" database structures (using various ... toes into this client / server corporate database water before (if ... There is also a free version of MySQL. ...
    (microsoft.public.vb.general.discussion)
  • Database Stuff
    ... Being a hobbyist and writing mostly stand alone utilities for myself and friends I have always "rolled my own" database structures and they have always previously suited my purposes, being just about as fast as anything you can get but, of course, being specific to my own particular stand alone application and being unsuitable for read and write access by more than one person at a time. ... Now my daughter has asked if I can write something for her which performs the sort of tasks and creates the sort of displays that I've always done before, but which can be used by a number of separate people on a number of separate machines such that each person is accessing the same database at the same time for both read and write operations and, if necessary, for the creation of new records. ...
    (microsoft.public.vb.general.discussion)
  • Re: Database Stuff
    ... friends I have always "rolled my own" database structures (using various ... of separate machines such that each person is accessing the same database ... toes into this client / server corporate database water before (if that's ...
    (microsoft.public.vb.general.discussion)
  • Re: Database Stuff
    ... friends I have always "rolled my own" database structures (using various ... the sort of tasks and creates the sort of displays that I've always done ... of separate machines such that each person is accessing the same database ...
    (microsoft.public.vb.general.discussion)
  • Re: Primary Key not sorted
    ... Are you willing to rely on any "natural" sort of records? ... > though the Company field is the Primary Key but if I ... When I Compact and Repair the database it ...
    (microsoft.public.access.tablesdbdesign)