Create MS/ACCESS database app for non-ms/access users

[Sue Bricker]

Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?

I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.

SueB

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[(Pete Cresswell)]

Per Sue Bricker:

Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?

I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.

I think it comes down to semantics.

"Licensed" vs "Loaded".

No you can't create an app that will run on a PC with nothing loaded.

Yes you can create an app that will run on a PC where nobody's paid the fee to
run MS Access.
You still have to install something on that PC, however. What it is is a
freebie version of MS Access that only runs applications - doesn't allow anybody
to develop an app.

You develop the app on your PC, which has MS Access installed.

Then somebody installs the freebie ("Runtime Access") on somebody's PC and they
can run the app you developed without having to pay any money to anybody.
--
PeteCresswell

[Alan Webb]

Sue,
If Access isn't present, some version of it must be installed to run an
Access database. VB.NET, or VB6 or some other commercial IDE that will let
you author code you own may initially be harder to learn and more work but
is worth the extra effort.

"Sue Bricker" <sb****@att.net > wrote in message
news:42******** **@127.0.0.1...

Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?

I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.

SueB

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Sue Bricker]

Pete,

Thanks for the info. Is this "Runtime Access" readily available for
download? From where?

Thanks.
Sue

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Sue Bricker]

Alan,

I am not sure if I understand your answer. I do have MS/Access
loaded/liscenced on my PC, where I plan on doing the devlopment. I have
been asked to create a database for someone who may or may not have
MS/Access on their PC. Is this possible? The previous response to my
question says that this is possible if the "end user" has a "Runtime
Only Version of Access". So I need to get my hands on this appl.

Thanks.
Sue
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Sue Bricker]

Alan,

I misread your reply. I understand what you were saying and I'll look
into those other options. Thanks.

SueB

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[David W. Fenton]

"Alan Webb" <kn*****@hotmai l.com> wrote in
news:rZ******** ************@co mcast.com:

If Access isn't present, some version of it must be installed to
run an Access database. VB.NET, or VB6 or some other commercial
IDE that will let you author code you own may initially be harder
to learn and more work but is worth the extra effort.

You can't run an Access application with VB.

You could completely rewrite the application in VB and use the data
tables from the Access MDB, but that's a ridiculous alternative in
comparison to the runtime.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[David W. Fenton]

Sue Bricker <sb****@att.net > wrote in news:42******** **@127.0.0.1:

I misread your reply. I understand what you were saying and I'll
look into those other options. Thanks.

Alan's answer was ridiculously unhelpful, because it would require
recreating your Access application entirely from scratch in a
different version of VB that doesn't have anywhere near the built-in
capabilities for working with data.

In comp.databases. ms-access, it's generally said by developers who
work both in Access and in VB that a VB version will take at least
3X as much work as the equivalent Access application.

And its only advantage over Access is a somewhat simpler
installation process.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Matt Furze]

Sue,

The answer to your question is "yes" - you need the Package and Deployment
Wizard - depends on which version of Access you're using. For Access 2003,
you'll need to purchase Visual Studio 2003, which include what you need to
package your application, and include the runtime version of Access. For
Access 2000, there was a Developer's version of Office 2000, and also a
separate Developer's Tools package that included the runtime version of
Access. Access XP I'm sure has something similar; a check on Microsoft's
site will tell you what you need.

Matt

"Sue Bricker" <sb****@att.net > wrote in message
news:42******** **@127.0.0.1...

Is it possible to create an MS/ACCESS database application and package
it for users who do not have MS/ACCESS loaded in their PCs?

I was told that this is possible, but I don't know what software is
needed. Do you know? If so, please answer this post. Thanks.

SueB

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Mike]

Unless Microsoft has changed it's policy, the runtime version does not
have ALL the features of the full version (but it is still quite good).
For example in the past Query by Form was not available in the runtime
version.