I have a Access 2002 DB that I want to Change into a Stand Alone Programme
( Not needing MS Access) so as I can sell to my friends.
Any suggestions how I can go about this lawfully??? Thanks for any advise,
Kim Wright
John W. Vinson - 09 Aug 2007 07:12 GMT
>I have a Access 2002 DB that I want to Change into a Stand Alone Programme
>( Not needing MS Access) so as I can sell to my friends.
>Any suggestions how I can go about this lawfully???
Discard it and redesign it from scratch, in some program such as C++, VB.NET
or Visual Basic.
Access applications cannot - by their design and by the fact that they exist
only because of the Access programming environment - be compiled into
standalone programs.
You *can* get a Runtime version of Access; it's even free with A2007. But to
run an Access application you need Access.
John W. Vinson [MVP]
Bob V - 09 Aug 2007 09:00 GMT
Thanks John. So if you have A2007 you can give it to your friend and if he
does not have Access he can use it??
>>I have a Access 2002 DB that I want to Change into a Stand Alone Programme
>>( Not needing MS Access) so as I can sell to my friends.
[quoted text clipped - 14 lines]
>
> John W. Vinson [MVP]
Jackie L - 09 Aug 2007 16:08 GMT
I have not used the runtime with v2007 but the previous versions required you
to install a file on the workstation which does not have Access. Then a
compiled version of an Access database can be run on that workstation (the
design cannot be edited).
> Thanks John. So if you have A2007 you can give it to your friend and if he
> does not have Access he can use it??
[quoted text clipped - 17 lines]
> >
> > John W. Vinson [MVP]
John W. Vinson - 09 Aug 2007 17:22 GMT
>Thanks John. So if you have A2007 you can give it to your friend and if he
>does not have Access he can use it??
You need to give them both the database - .mdb or a "compiled" .mde file - and
the runtime version of the Access program msaccess.exe. It gets installed
along with a whole bunch of .dll files; the runtime verision is "crippled" so
that you can use an existing database, but not make any design changes to
forms, reports, etc.
Check out Tony Toews' website http://www.granite.ab.ca/access. He has a whole
section on distributing applications. It's quite a bit of work to do it right,
but the bottom line is... yes, your friend can use your database without
having to purchase Access.
John W. Vinson [MVP]
Bob V - 09 Aug 2007 23:58 GMT
Thanks John, Do you know where you can download Runtime
Thanks for the advise.............Bob
>>Thanks John. So if you have A2007 you can give it to your friend and if he
>>does not have Access he can use it??
[quoted text clipped - 15 lines]
>
> John W. Vinson [MVP]
John W. Vinson - 10 Aug 2007 00:37 GMT
>Thanks John, Do you know where you can download Runtime
>Thanks for the advise.............Bob
http://msdn2.microsoft.com/en-us/office/bb229700.aspx
(Thanks to Tony Toews' excellent website www.granite.ab.ca/access)
John W. Vinson [MVP]
scubadiver - 09 Aug 2007 08:16 GMT
If requested, a computer can have Access installed when bought. If not then
a Windows installation disk should come with the computer.

Signature
www.ae911truth.org
> I have a Access 2002 DB that I want to Change into a Stand Alone Programme
> ( Not needing MS Access) so as I can sell to my friends.
> Any suggestions how I can go about this lawfully??? Thanks for any advise,
> Kim Wright
Jan Poller - 25 Sep 2007 12:24 GMT
Use the new Access runtime 2007 for your friends. It runs Access 2002
databases. I have run 2002Databases on it. DO NOT INSTALL IT ON YOUR
DEVELOPMENT MACHINE. it will disable your 2002 Access. Set up a virtual
machine for testing.
> I have a Access 2002 DB that I want to Change into a Stand Alone Programme
> ( Not needing MS Access) so as I can sell to my friends.
> Any suggestions how I can go about this lawfully??? Thanks for any advise,
> Kim Wright
Bob V - 25 Sep 2007 23:24 GMT
Thanks Jan is Runtime free and where would I down load it from, Thanks for
your advise ....Bob
> Use the new Access runtime 2007 for your friends. It runs Access 2002
> databases. I have run 2002Databases on it. DO NOT INSTALL IT ON YOUR
[quoted text clipped - 7 lines]
>> advise,
>> Kim Wright