Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / September 2007

Tip: Looking for answers? Try searching our database.

Some Advise Needed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Bob V - 09 Aug 2007 06:18 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??? 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.