Hi,
We're are about to develop an app in C# that will use a MS Access
database file for data storage. The db structure will not be
modified. The user will use the C# developed app to view and edit the
data (as well as add/delete records etc.).
In order to distribute or app (including .mdb file) to PC's without MS
Access installed do we need anything (I'm thinking specically about
the MS Access Runtime)?
What are the licensing implications for distributing access databases
(not access) to PC's without Access installed?
Regards and thanks,
Nick
P.S. This is going to be our first C# project after years with
Borland Builder. If anyone else has made the transition and has any
tales to tell I would be very interested in hearing them here or ni*****@yahoo.c o.uk 9 2717
Nick
I am under the impression that you need to have the Developer's Edition to
distribute .mdbs and the Runtime, OR, the user needs to have MS Access.
This is just an impression.
Have you checked for information on the Microsoft site?
--
Good luck
Jeff Boyce
<Access MVP>
Distributing an mdb file requires no license. The runtime allows one to
distribute an Access front-end. If being read from and written to by C#, you
won't need the Access runtime since you already have a front-end.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
"Nick" <ni*****@yahoo. co.uk> wrote in message
news:24******** *************** **@posting.goog le.com... Hi,
We're are about to develop an app in C# that will use a MS Access database file for data storage. The db structure will not be modified. The user will use the C# developed app to view and edit the data (as well as add/delete records etc.).
In order to distribute or app (including .mdb file) to PC's without MS Access installed do we need anything (I'm thinking specically about the MS Access Runtime)?
What are the licensing implications for distributing access databases (not access) to PC's without Access installed?
Regards and thanks,
Nick
P.S. This is going to be our first C# project after years with Borland Builder. If anyone else has made the transition and has any tales to tell I would be very interested in hearing them here or ni*****@yahoo.c o.uk
"Nick" <ni*****@yahoo. co.uk> wrote in message
news:24******** *************** **@posting.goog le.com...
Firstly, please don't crosspost... In order to distribute or app (including .mdb file) to PC's without MS Access installed do we need anything (I'm thinking specically about the MS Access Runtime)?
No - the MS Access Runtime is for running actual Access applications, not C#
applications which interface with a Jet database file (.MDB).
What are the licensing implications for distributing access databases (not access) to PC's without Access installed?
None.
Thanks, Arvin. I wasn't familiar with the "arcania" of the licensing.
Nick, pardon my mis-understanding.
Jeff Boyce
<Access MVP>
"Arvin Meyer" <a@m.com> wrote in message
news:ep******** *****@tk2msftng p13.phx.gbl... Distributing an mdb file requires no license. The runtime allows one to distribute an Access front-end. If being read from and written to by C#,
you won't need the Access runtime since you already have a front-end. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
"Nick" <ni*****@yahoo. co.uk> wrote in message news:24******** *************** **@posting.goog le.com... Hi,
We're are about to develop an app in C# that will use a MS Access database file for data storage. The db structure will not be modified. The user will use the C# developed app to view and edit the data (as well as add/delete records etc.).
In order to distribute or app (including .mdb file) to PC's without MS Access installed do we need anything (I'm thinking specically about the MS Access Runtime)?
What are the licensing implications for distributing access databases (not access) to PC's without Access installed?
Regards and thanks,
Nick
P.S. This is going to be our first C# project after years with Borland Builder. If anyone else has made the transition and has any tales to tell I would be very interested in hearing them here or ni*****@yahoo.c o.uk
To extend the original question a bit. If developing a C# app that uses an
access database should I install the latest Jet drivers during my apps
installation?
As I understand it MDAC no longer comes with Jet drivers so there is no need
to install MDAC. I believe there is a separate installer for the Jet
drivers. Should I be concerned with installing this to make sure the Jet
drivers are there or can I assume that every Windows machine has some
version of Jet? Or does the .Net Framework 1.1 include everything I need to
manipulate access databases?
Please correct me if I've made any incorrect statements above.
-Brett-
"Arvin Meyer" <a@m.com> wrote in message
news:ep******** *****@tk2msftng p13.phx.gbl... Distributing an mdb file requires no license. The runtime allows one to distribute an Access front-end. If being read from and written to by C#,
you won't need the Access runtime since you already have a front-end. -- Arvin Meyer, MCP, MVP Microsoft Access Free Access downloads: http://www.datastrat.com http://www.mvps.org/access
"Nick" <ni*****@yahoo. co.uk> wrote in message news:24******** *************** **@posting.goog le.com... Hi,
We're are about to develop an app in C# that will use a MS Access database file for data storage. The db structure will not be modified. The user will use the C# developed app to view and edit the data (as well as add/delete records etc.).
In order to distribute or app (including .mdb file) to PC's without MS Access installed do we need anything (I'm thinking specically about the MS Access Runtime)?
What are the licensing implications for distributing access databases (not access) to PC's without Access installed?
Regards and thanks,
Nick
P.S. This is going to be our first C# project after years with Borland Builder. If anyone else has made the transition and has any tales to tell I would be very interested in hearing them here or ni*****@yahoo.c o.uk
"Brett Robichaud" <br************ @nospam.yahoo.c om> wrote in message
news:eD******** *****@TK2MSFTNG P10.phx.gbl... Or does the .Net Framework 1.1 include everything I need to manipulate access databases?
Yes it does. You need to reference either the System.Data.Ole Db namespace
(preferred) or the System.Data.Odb c namespace to provide connectivity with
your .MDB file, and everything you need from that point is included in the
..Net Framework.
E.g. if you wrote a WinForms app which used a .MDB file for database
services, all you would need to do would be to compile the app and deploy
it. At install time, the compiled app would detect the presence or absence
of the .NET Framework, and invite you to install it if wasn't already
installed.
Excellent. So I simply need to be sure the .Net Framework is installed and
my C# Winforms app can be guaranteed that all necessary MS Access drivers
are in place on the machine?
That is just what I wanted to hear.
Thanks...
-Brett-
"Mark Rae" <ma**@mark-N-O-S-P-A-M-rae.co.uk> wrote in message
news:Om******** ********@TK2MSF TNGP10.phx.gbl. .. "Brett Robichaud" <br************ @nospam.yahoo.c om> wrote in message news:eD******** *****@TK2MSFTNG P10.phx.gbl...
Or does the .Net Framework 1.1 include everything I need to manipulate access databases?
Yes it does. You need to reference either the System.Data.Ole Db namespace (preferred) or the System.Data.Odb c namespace to provide connectivity with your .MDB file, and everything you need from that point is included in the .Net Framework.
E.g. if you wrote a WinForms app which used a .MDB file for database services, all you would need to do would be to compile the app and deploy it. At install time, the compiled app would detect the presence or absence of the .NET Framework, and invite you to install it if wasn't already installed.
Brett,
Actually you will need MDAC 2.7 or greater to use an access back end so
you have to install that manually or integrate it into your distribution.
Also the newer version of MDAC don't include the Jet database engine files
see http://support.microsoft.com/default...b;en-us;239114 for
instructions on downloading the latest Jet 4.0 service pack which does
contain the files needed to use an Acess database under MDAC. I'd reccomend
using MDAC 2.8 as there have been some improvements in the engine's
performace with the latest version.
Ron Allen
"Brett Robichaud" <br************ @nospam.yahoo.c om> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Excellent. So I simply need to be sure the .Net Framework is installed
and my C# Winforms app can be guaranteed that all necessary MS Access drivers are in place on the machine?
That is just what I wanted to hear.
Thanks...
-Brett-
"Mark Rae" <ma**@mark-N-O-S-P-A-M-rae.co.uk> wrote in message news:Om******** ********@TK2MSF TNGP10.phx.gbl. .. "Brett Robichaud" <br************ @nospam.yahoo.c om> wrote in message news:eD******** *****@TK2MSFTNG P10.phx.gbl...
Or does the .Net Framework 1.1 include everything I need to manipulate access databases?
Yes it does. You need to reference either the System.Data.Ole Db
namespace (preferred) or the System.Data.Odb c namespace to provide connectivity
with your .MDB file, and everything you need from that point is included in
the .Net Framework.
E.g. if you wrote a WinForms app which used a .MDB file for database services, all you would need to do would be to compile the app and
deploy it. At install time, the compiled app would detect the presence or
absence of the .NET Framework, and invite you to install it if wasn't already installed.
Argh! Thank you for correcting me on this issue. This is in fact what I
was originally expecting. I was elated to hear from another poster that I
need not worry about this, so I am a bit dissapointed now of course.
But thanks for giving me more correct info. I would undoubtedly have run
into problems had I taken the original advice.
-Brett-
"Ron Allen" <rallen@_nospam _src-us.com> wrote in message
news:eX******** ******@TK2MSFTN GP11.phx.gbl... Brett, Actually you will need MDAC 2.7 or greater to use an access back end
so you have to install that manually or integrate it into your distribution. Also the newer version of MDAC don't include the Jet database engine files see http://support.microsoft.com/default...b;en-us;239114 for instructions on downloading the latest Jet 4.0 service pack which does contain the files needed to use an Acess database under MDAC. I'd
reccomend using MDAC 2.8 as there have been some improvements in the engine's performace with the latest version.
Ron Allen "Brett Robichaud" <br************ @nospam.yahoo.c om> wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Excellent. So I simply need to be sure the .Net Framework is installed and my C# Winforms app can be guaranteed that all necessary MS Access
drivers are in place on the machine?
That is just what I wanted to hear.
Thanks...
-Brett-
"Mark Rae" <ma**@mark-N-O-S-P-A-M-rae.co.uk> wrote in message news:Om******** ********@TK2MSF TNGP10.phx.gbl. .. "Brett Robichaud" <br************ @nospam.yahoo.c om> wrote in message news:eD******** *****@TK2MSFTNG P10.phx.gbl...
> Or does the .Net Framework 1.1 include everything I need to > manipulate access databases?
Yes it does. You need to reference either the System.Data.Ole Db namespace (preferred) or the System.Data.Odb c namespace to provide connectivity with your .MDB file, and everything you need from that point is included in the .Net Framework.
E.g. if you wrote a WinForms app which used a .MDB file for database services, all you would need to do would be to compile the app and deploy it. At install time, the compiled app would detect the presence or absence of the .NET Framework, and invite you to install it if wasn't already installed.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ed Landau |
last post by:
Hi: I've just developped a really simple MS Access App. The VBA runs
within the database. It uses some DLLs which I register with a script.
It's on MS Access2003 (Office11). I've got 2003Pro but could get Ent.
Never having done this before, I'm not sure what I need to do in order to be
able to distribute it. I'd like not to require other users to have Access
installed (let alone 2003). For starters, I'm just looking to be able...
|
by: Larry__Weiss |
last post by:
What kind of licensing is needed to be able to use the Microsoft Access product
and distribute the applications? In other words, what version of Microsoft Access
does a developer need to buy in order to allow distribution of the runtime components
without incurring any additional license fees per installation of the runtime?
Has this changed very much over the versions of MS Access (especially since Access 2.0)?
- Larry Weiss
|
by: Rufus DeDufus |
last post by:
I want to write an app that uses the jet back end. What Access (Jet)
binaries must I distribute? Where do I get (that is, what must I purchase)
to get the Jet bits and the rights to distribute?
Reply to sporkmeupscotty@hotmail.com
Thanks.
|
by: pw |
last post by:
Hi,
I can't find anything about a toolkit on Microsoft site or what is
needed to distribute an Access 2003 application (like the SDK w/
Access 97).
I assume this is still possible. What do I need to create the setup
files?
-pw
|
by: Nick |
last post by:
Hi,
We're are about to develop an app in C# that will use a MS Access
database file for data storage. The db structure will not be
modified. The user will use the C# developed app to view and edit the
data (as well as add/delete records etc.).
In order to distribute or app (including .mdb file) to PC's without MS
Access installed do we need anything (I'm thinking specically about
the MS Access Runtime)?
| |
by: Darius |
last post by:
How to distribute a C program into many C files ?
this is the first question a C programmer asks after learning C basics,
Questions like
--what is a header file
--where should i put global variables
--where should i put declaration and definitions
--where should i put macros
--when to use static functions and variables
|
by: Bob Alston |
last post by:
Is it considered best practice to distribute FE databases as MDEs rather
than MDBs? Without flaming me for asking the question, could someone
please enumerate the key advantages?
Also I like to provide my users a mini report writer where the report
specs are stored as local data files. Can I do this in an MDE - e.g.
have local data files for the report writer spec but no queries, forms
or report changes?
Thanks.
|
by: akbar |
last post by:
Hi,
I am creating not-so-important opensource application written in python
for Linux. I have two files python source in src directory, named
blabla1.py and blabla2.py. There are byte compiled files too, named
blabla1.pyc and blabla2.pyc. Should I distribute these files (pyc
files) to users? If I don't distribute them, and user installed my
application into /usr (not writable by normal user) then run it as
normal user, off course, the...
|
by: jackbenimble999 |
last post by:
Hello!
I'd like to distribute an application developed in MS Access 2003.
I've looked at the MS web site and it says although the ability to
distribute is included with MS Office Retail, you still need to
purchase a licence, yet it provides no links.. It also says that you
need developer extensions to package it, but still no link! .Overall,
I'm a bit confused and am wondering if anyone can set me on the right
track.
|
by: sms1973 |
last post by:
Hello,
I have built an application web site using ASP.NET 2003 and MSSQL
database server.
I now need to distribute the entire application to customers on a CD
to run the web application completely from their local personal
computers. In other words, they will not need to access the Internet
to run the application.
I know I can use the redistributable MSSQL EMMSDE for the database
part, but my problem is that I want users to run the site...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |