Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 16th, 2004, 09:19 AM
Authorized User
 
Join Date: Apr 2004
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default Releasing VBA Application

Hi,

Is there a way for me to release my application to my users without them being able to see my code? To only give them access to the form I created and not the code behind it?

Thanks!!!
-mays

 
Old June 16th, 2004, 11:31 AM
Authorized User
 
Join Date: May 2004
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Change from MDB to MDE
 
Old June 17th, 2004, 12:06 AM
Authorized User
 
Join Date: Oct 2003
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Or you can, from the VBE window, select Tools => "(YourProjectName)Properties" => "Protection" Tab => "Lock Project for viewing"
This is a built in option. It locks access to the VBE window, unless one is privy to the password you assign, after checking the
"Lock Project for viewing" chkbox.

just another option, good Luck!






Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add Macro in other OutLook Application VBA kvingupta All Other Wrox Books 0 April 3rd, 2006 05:38 AM
Disposing / Releasing objects yamyam C# 5 February 17th, 2006 04:06 AM
'Application.ThisCell" equivelent for VBA 2000? gws_byte Excel VBA 3 January 31st, 2006 09:17 AM
Releasing Memory in Access Paulsh Access VBA 2 August 24th, 2005 07:32 AM
Application Defined Error in Excel VBA mahanti BOOK: Professional Crystal Reports for VS.NET 0 May 27th, 2005 12:38 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.