473,324 Members | 2,370 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

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



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!
Nov 13 '05 #1
10 2322
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
Nov 13 '05 #2
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!

Nov 13 '05 #3
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!
Nov 13 '05 #4

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!
Nov 13 '05 #5


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!
Nov 13 '05 #6
"Alan Webb" <kn*****@hotmail.com> wrote in
news:rZ********************@comcast.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
Nov 13 '05 #7
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
Nov 13 '05 #8
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!

Nov 13 '05 #9
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.

Nov 13 '05 #10

THANK YOU, ALL, for your replies. Since I'm in the market for a new PC,
I'll just wait until I get Office 2003 Professional and then get the
Visual Studio with the Developers Tool Kit included. I can't wait to
give it a go.

Thanks again.
SueB
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 13 '05 #11

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Shashikant Khandelwak | last post by:
Hi ! I am trying to install oracle 9i Standard edition on a windows 2000 SP4 machine. I get through the entire installation up to running the Database Configuration Assistant. While it tries to...
3
by: Michael Lauzon | last post by:
This is not for a class, I have a group on SourceForge, this is what one of the Developers is asking; the more advanced you can make it right off all the better!: Can someone please create...
11
by: dfurtney | last post by:
SQL Server 7/2000: We have reasonably large tables (3,000,000 rows) that we need to add some indexes for. In a test, it took over 12 hours to CREATE a new INDEX against this table. One of us...
3
by: Evan Smith | last post by:
I have a federated database (7.2 FP11, AIX 4.3) that seems to work fine in most aspects. Today I'm trying to add a new user mapping with the following statement: create user mapping for mngdrq01...
9
by: jab | last post by:
Je veux lier (join) une table qui se trouve dans une database avec une qui se trouve dans une autre database. Les 2 databases sont sur le même serveur en l'occurence DB2/NT 7.2.9. J'ai créé un...
2
by: Maverick | last post by:
If i try to create foxpro table by the following "sql" statment, the C# compiler will only return an error "xxxx not support in non-dbc version". The "index on" command statement return some kind...
5
by: darjonase | last post by:
Alright, so I am creating an entire database in code since I have no idea how to bundle a created database in an install of my application. I know how to create the database and the tables in...
19
by: Brett Romero | last post by:
Here's a table of data I'm putting into a collection: CodeId CodeGroup CodeSubGroup Type 1 K K.1 Shar1 2 K ...
2
by: cpressley2 | last post by:
Hi, On a multi-partition instance, can you create a database on a single parition? How??? The db architects want to use one instance for four databases where only one is big enough for a...
7
by: | last post by:
There are assorted "SQL Injection vulnerability assessment tools" out there. They scan your site and send your report. They also take your money. We don't have the money so I was wondering if I...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.