转换MS Access应用程序 [英] Conversion of an MS Access application

问题描述

我已经在MS Office XP下构建了一个MS Access应用程序（但我也是一个拥有MS Office 2000的
）。我已将应用程序拆分为纯数据库

表和所有查询，表单，报告和宏'。


现在我想用这个申请不同的基金会在

荷兰，但我想保证我的申请，所以没有人可以更改

，复制或从我这里偷走它。我一直认为有一种

转换工具可以将整个应用程序转换为EXE

程序。但我从不同的讨论中了解到，我必须将我的MDB转换为MDE并向其添加一个Access运行程序。在

这种情况​​下，我绝不能阻止人们窃取我的数据库

概念与所有表格和关系也不能阻止他们

复制东西。是否有更好的解决方案可供选择？

是否需要花费？


我是一位非常有经验的计算机用户（自1958年以来）和PC用户以及

认为自己是数据库专家！


热切期待任何解决方案

I have built an MS Access Application under MS Office XP (but I also
own MS Office 2000). I have split the application in the pure database
tables and all the queries, forms, reports and macro''s.

Now i want to use this application for different foundations in the
Netherlands but I want to secure my application so no one can change
it, copy it or steal it from me. I always thought there was a kind of
conversion tool that would translate the whole application into an EXE
program. But I understood from the different discussions that I have to
translate my MDB''s to MDE''s and add an Access run program to it. In
this case I can in no way prevent people from stealing my database
concept with all the tables and relations neither can I prevent them to
copy things. Is there a better solution available somewhere and what
does it cost?

I am a very experienced computer user (since 1958) and PC user and
consider myself as a database expert!

Eagerly looking forward to any solutions

推荐答案

2006年2月25日12:09:11 -0800，Oldie < ke*@hiquad.demon.nl>写道：


然后你应该知道没有完美的安全性。


MDE防止窃取您的代码：只编译版本在那里是
，你的应用程序可能并不重要，有人会b / b
bother反编译它。


一个选项是使用Access安全性。下载，学习并完全

在

继续之前了解microsoft.com的访问安全常见问题解答。再一次作为专家你已经知道所有这一切，再加上你知道这个安全性可以通过互联网上提供的任意数量的密码

破解者来解决。


另一种选择是使用加密狗来保护您的应用程序：硬件密钥

进入串行，并行或USB端口，如果没有找到

你的代码，你的应用程序不会运行。我使用过aladdin.com的产品和

他们很容易合作。


鉴于我所说的Access，数据库设计无法得到保护

安全。将它视为您向全世界的礼物:-)或考虑另一个具有更高安全级别的
数据库平台，例如

SQL Server 2005 Express Edition。


-Tom。

On 25 Feb 2006 12:09:11 -0800, "Oldie" <ke*@hiquad.demon.nl> wrote:

Then you should know there is no such thing as perfect security.

MDE protects against stealing your code: only the compiled version is
there, and your app is probably not THAT important that someone would
bother decompiling it.

One option is to use Access security. Download, study, and fully
understand the Access Security FAQ from microsoft.com before
proceeding. Again as an expert you already know all of this, plus you
know that this security can be broken by any number of password
crackers available on the Internet.

Another option is to protect your app with a dongle: a hardware key
that goes in the serial, parallel or USB port, and if not found by
your code, your app won''t run. I''ve used products from aladdin.com and
they were straightforward to work with.

The database design cannot be protected given what I said about Access
security. Consider it your gift to the world :-) or consider another
database platform with higher levels of security available, such as
SQL Server 2005 Express Edition.

-Tom.

我在MS Office XP下构建了MS Access应用程序（但我也拥有MS Office 2000） ）。我已将应用程序拆分为纯数据库表和所有查询，表单，报表和宏。
现在我想将此应用程序用于程序。但我从不同的讨论中了解到，我必须将我的MDB转换为MDE并向其添加Access运行程序。在这种情况下，我绝不能阻止人们窃取我的数据库
概念与所有的表和关系，我也不能阻止他们复制东西。是否有更好的解决方案可供选择？

我是一位非常有经验的计算机用户（自1958年起）和PC用户以及
认为自己是数据库专家！

热切期待任何解决方案

I have built an MS Access Application under MS Office XP (but I also
own MS Office 2000). I have split the application in the pure database
tables and all the queries, forms, reports and macro''s.

Now i want to use this application for different foundations in the
Netherlands but I want to secure my application so no one can change
it, copy it or steal it from me. I always thought there was a kind of
conversion tool that would translate the whole application into an EXE
program. But I understood from the different discussions that I have to
translate my MDB''s to MDE''s and add an Access run program to it. In
this case I can in no way prevent people from stealing my database
concept with all the tables and relations neither can I prevent them to
copy things. Is there a better solution available somewhere and what
does it cost?

I am a very experienced computer user (since 1958) and PC user and
consider myself as a database expert!

Eagerly looking forward to any solutions

你当然可以，而且应该隐藏所有的ms - 访问界面。

选项可以使用tools->启动选项轻松完成隐藏并让人们远离ms访问界面

。使用这些选项允许

你完成隐藏ms访问界面（工具栏，数据库窗口

等）。此外，使用这些选项意味着你

不必费心设置安全性。


尝试在我的以下网站下载并运行第3个示例

显示一个隐藏的ms访问界面，并且需要NO CODE才能执行这个....但只是启动时的一些设置。


退房：

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm


尝试申请后，您可以退出，然后重新加载

应用程序，但按住shift键以绕过启动选项。如果

想要，你甚至可以通过传递来禁用shift键。我有一个示例mdb文件

，它可以让你设置您想要的任何应用程序上的shift键旁路。

您可以在以下位置获得此信息：
http://www.members.shaw.ca/AlbertKal.../msaccess.html


你真正需要对上面的例子做的唯一额外的事情是

将它转换为mde ...


我也有一些屏幕截图..以及我如何使用自定义菜单的一些想法

栏在ms访问：

http://www.members.shaw.ca/AlbertKal...erFriendly.htm

另外，我还可以提出一些关于如何设置

启动选项的想法...


当然，在开发过程中，你将按住shift键，这样你的
启动设置就不会运行了。然后你开发一段时间，然后在

" user"中进行测试。模式，你退出..然后重新进入应用程序没有转移

键被绕过。当你运行/测试

用户模式时，你可能整天都会跳这个舞蹈，然后再回到开发者模式（使用shift键......所以你需要

没有主要的自定义菜单）。因此，当您使用启动设置运行应用程序时，您无法开发或真正修改

事物...所以您必须

按顺序移动它们当你想工作的时候。


事实上，我使用alt-f4退出应用程序... mdb文件应该

仍然会突出显示在windows explore..so中，然后按下回车键

（如果需要，按住shift键）。退出并重新进入应用程序的关键笔划序列和

将在您开发过程中一整天发生

。


当你终于把事情做对了......你创建mde

你打算分发......


-

Albert D. Kallal（访问MVP）

加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
http://www.members.shaw.ca/AlbertKallal

You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you
do not have to bother setting up security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKal...s/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:
http://www.members.shaw.ca/AlbertKal.../msaccess.html

The only additional things you really need to do to the above sample would
be to convert it to a mde...

I also have some screen shots..and some ideas as to how I use custom menu
bars in ms-access here:

http://www.members.shaw.ca/AlbertKal...erFriendly.htm
Also, I might as well give some ideas as to how one develops once you setup
the startup options...

Of course, during development, you will hold down the shift key so your
startup settings don''t run. You then develop for awhile, and then to test in
"user" mode, you exit..and then re-enter the application without the shift
key bypassed. You will likely do this dance all day long as you run/test as
user mode, and then flip back in to developer mode (shift key used..so you
don''t get the main custom menu). So, you can''t develop, or really modify
things when you run your application with the startup settings...so you must
shift-by-pass them when you want to work.

And, in fact, I use alt-f4 to exit the application...the mdb file should
still be highlighted in the windows explore..so, then you hit enter key
(and, hold down shift key if you need be). This key stroke sequence and
exiting and re-entering the application will occur CONSTANTLY all day long
when you are developing.

When you finally have things just right...you create the mde
you plan to distribute...

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

> ;我一直认为有一种

>I always thought there was a kind of

转换工具可以将整个应用程序翻译成一个EXE
程序。

conversion tool that would translate the whole application into an EXE
program.

不，你在这里有一个基本相同的概念，因为mde是你的
可执行文件。您可以购买ms-access的开发人员版本，因此将您的mde文件部署到没有安装ms-access的计算机上。请注意，这个运行时系统实际上是一个完整的ms访问安装，但只需删除设计功能就可以获得
（因此，这是一个大型安装）。我无法想到任何适用于数据库的软件，无论如何这些天都是简单的.exe文件（这种情况与幻灯片有关）

规则....）。


a2000的ms-access运行时大小为150兆（不是最好的

通过网络下载，例如）。但是，a2003运行时更容易管理33兆美元。
http://support.microsoft.com/default...b;en-us;842004

< a rel =nofollowhref =http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_ac2003_ta/html/odc_acbasicsofruntime.asp\"target =_ blank> http： //msdn.microsoft.com/library/de...sofruntime.asp
http://support.microsoft.com/default...b;en-us;842004

-

Albert D. Kallal（访问MVP）

加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
http://www.members.shaw.ca/AlbertKallal

no, you do have a essentially the same concept here, as a mde is your
executable. You can purchase a developers edition of ms-access, and thus
deploy your mde file to machines that don''t have ms-access installed. Be
aware, that this runtime system is in effect a full ms-access install, but
with just the design abilities removed (so, this is a large install). I
can''t really think of any software that works with a database that is a
simple .exe file these days anyway (That kind of went out with the slide
rule....).

The ms-access runtime for a2000 was a 150 megs in size (not the best for
downloading over the web for example). However, the a2003 runtime is a more
manageable 33 megs in size.
http://support.microsoft.com/default...b;en-us;842004

http://msdn.microsoft.com/library/de...sofruntime.asp
http://support.microsoft.com/default...b;en-us;842004
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

这篇关于转换MS Access应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！