problem: one database on more computers, no network. How to solve this?
Mark - "Bighead16" - Jansen
For our local orchestra, I'm writing a problem to do all the administration
with. To accomplish this, I wrote a program which manages a Acces 97
database. This means the program adds/deletes/updates records in the
database, since the people who are going to use it do not understand Access
or have it.
I'm using Visual Basic 5 to write the program with and now I thought I may
have a very big problem. It's like this: the BOD of our orchestra will be
using the program, but they all have their own pc and of course don't live
near each other. But I think there will be made some changes by them in the
same tables. How do I update these changes?
Suppose they all have Internet. Then downloading the database every time
they use the program isn't an option I think, since Access-database can grow
very rapidly. Or do I see that wrong? Please help me since this program will
be fully free for the BOD, but they do count on it to be completed quite
soon! Thanks in advance.
With regards,
Mark Jansen
contact: www.bighead.f2s.com
Henry Craven
>since the people who are going to use it do not understand Access
> or have it.
Your first hurdle will be to ensure that all your users get
a Licensed copy of access and install it.. You cannot store data
in an Access database that isn't there.
Your next, as Patrick points out is to learn to use and automate
Access Replication.
--
Henry Craven.
--------------------
hCr...@bigpond.net.au
------------------------------------
"Mark - "Bighead16" - Jansen" <ma...@mjansen.doge.nl> wrote in message
news:8np86p$gup$1...@thor.wirehub.nl...
Arvin Meyer
Anyone can distribute an mdb, whether it be a database or a front-end,
without a license. What you need a license for is to distribute an Access
runtime, and certain ActiveX controls.
---
Arvin Meyer
Henry Craven wrote in message ...
>Brian,
>You're right, Providing a Runtime version would.
>The runtime itself being a Crimped Install of MS Access.
>As Mark created a VB Frontend to an Access Database
>Data Store he will need to distribute both the VB and
>Access Runtime. ( And be Licensed to do so.)
>
>So, to answer your second Question. NO.
>If you do NOT own a Legal Copy of Office Developer
>you cannot Legally distribute copies of MS Access.
>
>The Database ( .mdb ) and MS Access are different things,
>and you can sell copies of the .mdb, - but that is useless to
>anyone without MS Access to run it on.
>
>--
>Henry Craven.
>--------------------
>hCr...@bigpond.net.au
>------------------------------------
>
>"BrianE (aka Good Ole Boy)" <goodol...@hotmail.com> wrote in message
>news:8npr2l$s4c$1...@ctb-nnrp2.saix.net...
>>
>> Henry Craven <Gospodyn...@Nyet.net> wrote in message
>> news:kxZn5.6713$Xg.6...@news-server.bigpond.net.au...
>> > Mark,
>> > >since the people who are going to use it do not understand Access
>> > > or have it.
>> >
>> > Your first hurdle will be to ensure that all your users get
>> > a Licensed copy of access and install it.. You cannot store data
>> > in an Access database that isn't there.
>>
>> Henry, please correct my thinking if I am wrong, but wouldn't a runtime
>> release of the app. circumvent the need for each PC to have a full
>> installation of Access? I suppose my next question, is if you don't have
>the
>> ODT (or ADT, depending on A97 or A2K), are you allowed to distribute
>runtime
>> files with your app? Not too difficult to do, but is it legal?
>>
>> Regards
>>
>> BrianE
>> Umtata
>> South Africa
>> (after a good weekend of Rugby and Cricket;-)))
>>
>>
>
>
BrianE (aka Good Ole Boy)
Peter Walker
Know how you feel, I write problems myself<g>
Thank God for CDMA
:-)
--
peter walker
51-L / 39B
various things available from
http://www.users.bigpond.com/papwalker/#Downloads
.
"Mark - "Bighead16" - Jansen" <ma...@mjansen.doge.nl> wrote in message
news:8np86p$gup$1...@thor.wirehub.nl...
> Hi all,
>
> For our local orchestra, I'm writing a problem to do all the
administration
> with. To accomplish this, I wrote a program which manages a Acces 97
> database. This means the program adds/deletes/updates records in the
> database, since the people who are going to use it do not understand
Access
> or have it.
>
Henry Craven
You're right, Providing a Runtime version would.
The runtime itself being a Crimped Install of MS Access.
As Mark created a VB Frontend to an Access Database
Data Store he will need to distribute both the VB and
Access Runtime. ( And be Licensed to do so.)
So, to answer your second Question. NO.
If you do NOT own a Legal Copy of Office Developer
you cannot Legally distribute copies of MS Access.
The Database ( .mdb ) and MS Access are different things,
and you can sell copies of the .mdb, - but that is useless to
anyone without MS Access to run it on.
--
Henry Craven.
--------------------
hCr...@bigpond.net.au
------------------------------------
"BrianE (aka Good Ole Boy)" <goodol...@hotmail.com> wrote in message
news:8npr2l$s4c$1...@ctb-nnrp2.saix.net...
>
David W. Fenton
<sZ_n5.6743$Xg.6...@news-server.bigpond.net.au>:
>As Mark created a VB Frontend to an Access Database
>Data Store he will need to distribute both the VB and
>Access Runtime. ( And be Licensed to do so.)
This is just flat out not true. VB apps that use a Jet back end do
not need to distribute the Access runtime.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Henry Craven
The licence for the Jet Database Engine is inherent in the VB Licence.
My Apologies.
Would I be right in saying then that Mark will also need to write his own
Replication Manager in that case ?
( ...presuming of course that he goes that path. )
--
Henry Craven.
--------------------
hCr...@bigpond.net.au
------------------------------------
"David W. Fenton" <dXXXf...@bway.net> wrote in message
news:8F96D030Ddf...@isp-east.usenetserver.com...
Henry Craven
> >If you do NOT own a Legal Copy of Office Developer
> >you cannot Legally distribute copies of MS Access.
> >The Database ( .mdb ) and MS Access are different things,
> >and you can sell copies of the .mdb,
Well, ... * I * know what I mean ...
:-(
( I think I'll just crawl into my nice warm hole ....
....has anyone see the Lid ? )
--
Henry Craven.
--------------------
hCr...@bigpond.net.au
------------------------------------
"Arvin Meyer" <a...@m.com> wrote in message
news:8nq3dj$fk$1...@slb7.atl.mindspring.net...
> Henry,
>
> Anyone can distribute an mdb, whether it be a database or a front-end,
> without a license. What you need a license for is to distribute an Access
> runtime, and certain ActiveX controls.
> ---
> Arvin Meyer
>
> Henry Craven wrote in message ...