Creating Executable file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey guys,

I have created a database system using Access 2003 and I would like to
create an executable file to make the system more secured.

can you please help me how to create an executable file like in other
programming languages like VB?

Or if you can suggest how am i going to protect my codes/database from
end-users.

Thank you.
 
hi Amsuria,
I have created a database system using Access 2003 and I would like to
create an executable file to make the system more secured.
Click to expand...
This is not possible with Microsoft Access.
can you please help me how to create an executable file like in other
programming languages like VB?
Click to expand...
Using another development environment means that you have to develope
every single form (and report) from the scratch.
Or if you can suggest how am i going to protect my codes/database from
end-users.
Click to expand...
Protecting the code is simple: Make your database a compiled one. This
only needs good error handling in your code.

Protecting the data and structure is possible, when you use the built-in
security - but this one is not 100% secure:

http://support.microsoft.com/kb/132143
http://support.microsoft.com/kb/289885
<http://msdn2.microsoft.com/en-us/library/aa662933( office.11).aspx>
http://office.microsoft.com/en-us/access/CH062526741033.aspx


mfG
--> stefan <--
 
I believe what Stefan means by making the database a compiled one is the
create a mde version of your database. This strips out the code and makes
the objects unchangeable and less accessible.
In reality, there is no development method that cannot be reverse engineered
if you have the knowledge, skill, and lack of ethics to do so.
 
can you please help me how to create an executable file like in other
programming languages like VB?
Click to expand...

Actually, VB could produce a .exe, but that .exe would ONLY function if you
INSTALLED THE VB RUNTIME library.

In other words, the concept of a stand alone .exe file has much gone the way
of the doo doo bird, and I can't think of any major development language of
the last 10 years that allowed the creating a .exe without any dependences.

so, we have:

If you write code in java, you need to install the java runtime.

If you write code in classic VB6, then you have to install the vb runtime.

If you write code in the .net languages, such as vb.net, then you have to
install the .net runtime.

While a few rare systems exist (such as c++) that allow you to create a
..exe, if you writing an application of any complexity, then that .exe will
require many other libraries. so, for example, if you write in c++, you need
to purchase a report writer, and then install that report writer BEFORE the
..exe will run. And, if that c++ application needs a database engine, then
you likely have to install and setup the database engine BEFORE the c++
"exe" you made will function.

So, if you been in "tune" with the general computing industry for the last
10 years, you be hard find pressed to find a database system, report writer,
and application development system that will produce stand alone .exe UNLESS
YOU INSTALL A RUNTIME SUPPORT LIBRARY

Ok, now that we got you up to speed on how modern languages and systems are
implemented, it turns out that there is also a runtime install of ms-access
available. Once this library is installed, then you simply create a "mde",
and then this mde can be installed on the target computer. (in fact, you can
just copy the mdb, or mde to the target computer...so, you have x-copy
developer ability just like .net, but ONLY after the runtime has been
installed).

for versions previous to a2007, the "runtime" system is a separate purchased
system.

For a2007, the runtime is a free download and install...

If you new to ms-access development, you need to start splitting your
database into an application part, and data part (this is must if you plan
to update your code for those that are running the runtime). I explain this
concept here:

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

Thus, after you split your database, then updates to the code part is the
simple copy of a "mde" to the target machine (a mde is a ms-access
executable, and if you have ms-access, or the access runtime installed, then
you can simply double click on this file..and your application will run just
like clicking on an .exe file).
 
Actually, I haven't touched it in years, but as I remember, FoxPro would
compile an exe without requiring the installation of a runtime. It included
the libraries needed at compile time. This did create some huge .exe files.
I don't that is still the case.
 
Back
Top