Hiding VBA code?

  • Thread starter Thread starter MN
  • Start date Start date
M

MN

Hello,
I want to copy a .mdb file to the user and they can run it
by MS Access in their own PC. But how can I hiding a VB
code? Please help,
Regards,MN
 
On the Tools > Database Utilities menu there is an option to create an MDE.
This is a copy of your MDB with all of the source code removed. It will not
allow the user to change any code, nor to modify any form, reports, macros,
or modules.

However, this is NOT the same as a VB executable file. The user must still
have Access on their machine. To make it something like self-executing, you
need to package it with the Access Run-time version. This is only available
in the Office Developers Edition (Access 2000 and XP).
 
Instead of giving them an MDB file, create an MDE file (Tools|Database
Utilities|Make MDE file) and give that to them.
 
Thanks for reply,
But I still want user able to modify the FORMAT of
reports,forms, ... but I do not want they are able to open
and edit VB code. Are these have the way to do that?
Regards,
MN
 
Thanks for reply,
But I still want user able to modify the FORMAT of
reports,forms, ... but I do not want they are able to open
and edit VB code. Are these have the way to do that?
Regards,
MN
 
Not that I know of.

Personally, I don't want my users modifying ANYTHING. If they want to
create their own reports, I will give them a second "reporting" database
with links to the tables and little else, that they can use at their own
risk.
 
Hi Roger,
How can I do that?
Regards,MN
-----Original Message-----
Not that I know of.

Personally, I don't want my users modifying ANYTHING. If they want to
create their own reports, I will give them a second "reporting" database
with links to the tables and little else, that they can use at their own
risk.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org




.
Click to expand...
 
MN said:
Thanks for reply,
But I still want user able to modify the FORMAT of
reports,forms, ... but I do not want they are able to open
and edit VB code. Are these have the way to do that?
Regards,
MN
Click to expand...

MN, Placing a password on the code should achieve what you are after.
Recognise the dangers of forgetting the password though!

Open any module in your database in design, Menu-> Tools, Properties,
Protection Select "Lock Project for Viewing" and set your password.
Users will then be prompted with the password box if they attempt to
go to code land.

Regards,
Kevin Rollo
Perth, Western Australia
 
Thank Kevin, that is what I want.
Regards,
MN
-----Original Message-----
"MN" <anonymous@discussions.microsoft.com> wrote in

MN, Placing a password on the code should achieve what you are after.
Recognise the dangers of forgetting the password though!

Open any module in your database in design, Menu-> Tools, Properties,
Protection Select "Lock Project for Viewing" and set your password.
Users will then be prompted with the password box if they attempt to
go to code land.

Regards,
Kevin Rollo
Perth, Western Australia
.
Click to expand...
 
Back
Top