473,327 Members | 1,919 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,327 software developers and data experts.

Access 2003 Run-Time

I am developing an HR package under Access 2003 for a client but do not
want to give him the source code.

I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this & what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)

I currently own a copy of MS Office Professional Edition 2003.

A detailed explanation would be very much appreciated including what
other software I would need to procure & what would be the approximate
cost of it ?

Thx & Best Rgds,
Prakash.

Dec 8 '06 #1
5 4557
Prakash wrote:
I am developing an HR package under Access 2003 for a client but do
not want to give him the source code.

I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this & what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)

I currently own a copy of MS Office Professional Edition 2003.

A detailed explanation would be very much appreciated including what
other software I would need to procure & what would be the approximate
cost of it ?

Thx & Best Rgds,
Prakash.
An MDE is nothing more than an MDB with the human readable source code
stripped out. One artifact of that is that all code based objects (forms,
reports, modules) cannot have their design altered or even viewed.

An MDE needs Access to be run just the same as an MDB does. Acquiring the
Developer's tools for Access that allow you to build and distribute a
royalty free runtime version of Access with your applications is a
completely different topic altogether from creating an MDE. They are
related only in that most people that distribute the runtime do so with an
MDE version of their file, but that is incidental and not a requirement.

If you are only concerned with people seeing your code or meddling with the
design it is far easier to just distribute MDEs and make the installation of
Access on the target PC a requirement of your application. Acquiring the
Developer's tools and distributing the runtime is neither trivial nor
inexpensive and really only "pays off" if you are distributing to a fairly
large number of users.

Note that an MDE does nothing to protect the viewing or changing of tables
and queries. For that you would have to go the additional step of applying
user level security (another non-trivial topic).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Dec 8 '06 #2
I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this
easy as pie:

tools->database utilities->make mde file.
what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)
Yes. They need a version of ms-access installed. You can either have them
purchase ms-access, or YOU can purchase the runtime edition of ms-access.
The runtime can be installed in place of the full version of ms-access, and
thus any mdb, or mde they place on their computer will then run. Once you
purchased the runtime, you can distribute this for free, and the end user
does not have to purchase ms-access.

It is also assumed that you split your database, as else how will you issue
the many bug fixes and updates to your software that you surely will
requite. I explain the split process here:

http://www.members.shaw.ca/AlbertKal...plit/index.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Dec 8 '06 #3
Rick & Albert ... A big thank you to you both ... Yes ... This
certainly solves my problem as this user has a copy of MS-Office
Professional on his PC.

Making the MDE does protect the code & that will suffice for the time
being.

However, if a user does not own a copy of MS-Access, then how do I
supply him with a run-time version. What would I have to purchase &
what would be the cost implications involved ?

Also ... Rick mentioned something about preventing a user from getting
to my table structures directly by using User-Level Security. I have a
couple of books on MS-Access and would love to read more about it.
Could you please point out which topics to read & any caveats to watch
out for ? Is it v.v.complicated ?

Thx & Best Rgds,
Prakash.



Albert D. Kallal wrote:
I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this

easy as pie:

tools->database utilities->make mde file.
what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)

Yes. They need a version of ms-access installed. You can either have them
purchase ms-access, or YOU can purchase the runtime edition of ms-access.
The runtime can be installed in place of the full version of ms-access, and
thus any mdb, or mde they place on their computer will then run. Once you
purchased the runtime, you can distribute this for free, and the end user
does not have to purchase ms-access.

It is also assumed that you split your database, as else how will you issue
the many bug fixes and updates to your software that you surely will
requite. I explain the split process here:

http://www.members.shaw.ca/AlbertKal...plit/index.htm
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Dec 9 '06 #4
Thx for the lovely detailed reply. It has certainly solved my immediate
problem. Please do read my reply under Albert's thread & guide me
further if possible.

Muchos Gracias & Best Rgds,
Prakash.


Rick Brandt wrote:
Prakash wrote:
I am developing an HR package under Access 2003 for a client but do
not want to give him the source code.

I understand that under these circumstances I would need to compile my
package, thus converting it into an MDE file. How do I go about doing
this & what would the client need to have installed on his PC ? i.e.
(Would the client need to have Access installed on his PC ?)

I currently own a copy of MS Office Professional Edition 2003.

A detailed explanation would be very much appreciated including what
other software I would need to procure & what would be the approximate
cost of it ?

Thx & Best Rgds,
Prakash.

An MDE is nothing more than an MDB with the human readable source code
stripped out. One artifact of that is that all code based objects (forms,
reports, modules) cannot have their design altered or even viewed.

An MDE needs Access to be run just the same as an MDB does. Acquiring the
Developer's tools for Access that allow you to build and distribute a
royalty free runtime version of Access with your applications is a
completely different topic altogether from creating an MDE. They are
related only in that most people that distribute the runtime do so with an
MDE version of their file, but that is incidental and not a requirement.

If you are only concerned with people seeing your code or meddling with the
design it is far easier to just distribute MDEs and make the installation of
Access on the target PC a requirement of your application. Acquiring the
Developer's tools and distributing the runtime is neither trivial nor
inexpensive and really only "pays off" if you are distributing to a fairly
large number of users.

Note that an MDE does nothing to protect the viewing or changing of tables
and queries. For that you would have to go the additional step of applying
user level security (another non-trivial topic).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Dec 9 '06 #5
"Prakash" <si****@omantel.net.omwrote in message
news:11**********************@j44g2000cwa.googlegr oups.com...
[snip]
Making the MDE does protect the code & that will suffice for the time
being.

However, if a user does not own a copy of MS-Access, then how do I
supply him with a run-time version. What would I have to purchase &
what would be the cost implications involved ?
You would need to acquire the Developer's Tools for Access 2003. This requires
both the Microsoft Visual Studio Tools for Office along with the Microsoft
Office Access 2003 Developer Extensions. I am not familair with the specifics
as I have only used the Developer's Tools for Access 97, but basically these
would allow you to build a custom installation propgram for your app that also
installs the Access Runtime. Purchase of these is also what gives you the
rights to legally distribute the runtime.
Also ... Rick mentioned something about preventing a user from getting
to my table structures directly by using User-Level Security. I have a
couple of books on MS-Access and would love to read more about it.
Could you please point out which topics to read & any caveats to watch
out for ? Is it v.v.complicated ?
I would suggest going to the microsoft.public.access.security newsgroup and
reading for a while. In that process you will hopefully avoid the common
problems and misperceptions about how Access security works. It is somewhat
counter-intuitive and complex and nearly all who attempt it for the first time
using only the wizards and the help file fail to end up with a properly secured
file. Once you've dug deep enough though and it "clicks" it is not that
difficult.

Within many of those articles you will find links to web articles that provide
very specific step by step instructions. I recommend using one or more of those
(on test files) until you are comfortable with it.

Access security is breakable with tools easily available by those who know how
to use Google, but as barriers in Access go it is the best one you will be able
to come up with. There are also many obfuscation techniques that can be used
instead of or in addition to user level security. You should find references to
many of those in that forum as well.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Dec 9 '06 #6

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

Similar topics

1
by: Ian Barnes | last post by:
I have a VB6 program that uses standard ADO 2.5 connection to read and write to an Access 97 database on a Windows 98 machine. The same program is run by a number of other people who use Windows 98...
14
by: wolftor | last post by:
1) Is there a free runtime version of Access available that is more recent than the one for Access 2000? 2) If I create an application (MDE) in A2K, will it run on all later versions of Access?...
1
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the...
2
by: Kelt | last post by:
I have a user who currently has Access 97 installed on her PC. She has purchased a new PC and would like to have Access installed on it. She would like to upgrade her current Access to Access...
2
by: Jeff | last post by:
Does anyone know of any potential problems running a 2000 database with 2003? Also, what about installing all other Office products as 2003 versions but leaving Access as 2002 running a 2000...
1
by: Tim Marshall | last post by:
I've just received a new computer with Win XP Version 5.1.2600. I want to have Access 2003 and Access 97 running on this, so I did some googling on cdma and it seems I must install these versions...
2
by: Philippe PERON | last post by:
Hello, An ACCESS application (mde) is installed on a computer looking at an mdb file on the same machine. As far as I know the application is installed thru a Wise Installer script. The...
0
by: Wayne | last post by:
Can anyone cast any light on the following. I have a database that I have written in Access 2003 using 2000 file format. Everything was working OK when running it under Access 2003 but when I...
4
by: RM | last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ...
17
by: Neil | last post by:
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
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: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
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.