"Bartosz Majewski" <yaa@killer.radom.net> wrote in message
news:c2g6sf$8tc$1@atlantis.news.tpi.pl...[color=blue]
> Hello,
> I have a question. Is there any possibility to compile MS Access database
> (e.g. *.mdb file) to standalone, executable application? I'd like to use
> such database application on a computer where Access is not installed. I
> know, that it's possible to write such kind of app in Visual Basic, but as
> far as I know, there cannot be any relations in that program (and that is
> why that solution is not, what I mean). I would be greateful for any piece
> of information, some tutorials maybe, knowledege base, or whatever...
>
> Thanx,
> Majek.
>
> --
> Bartosz Majewski
> yaa(at)killer.radom.net[/color]
Czesc Majek
This a very commonly asked question and you might want to do some searching
yourself here
http://groups.google.com
Certainly you could use Visual Basic and you would be able to define
relationships in the database. The main problem with creating your
application with VB instead of Access is that, in general, it takes longer.
MS Access has been designed specifically for the creation of databases and
the forms / subforms and the reporting features do make it very easy.
One common solution is to buy Microsoft Office Developer's Edition. This
allows you to distribute a legally licensed copy of Access with your
application. This is referred to as a run-time installation and although it
allows your application to run, it does not allow the user to, for example,
design new databases. Using this method does require extra time and extra
testing for you since unexpected errors can cause the application to simply
quit and throw you out and there are a number of features which are not
available (no built-in toolbars, no query by form etc).
There are other solutions depending on what you are distributing to whom.
However, the easiest for you is to get them to buy Access.
Fletcher