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

Protect VB code by automation

Is it possible to set a password to protect the code of an Access VBA
project by automation (I already know how to to it manually)?

David.
Nov 13 '05 #1
4 2210
On 4 Oct 2004 02:39:07 -0700, la**********@yahoo.fr (David LACASSAGNE)
wrote:
Is it possible to set a password to protect the code of an Access VBA
project by automation (I already know how to to it manually)?

David.

Hi
I suspect no-one has answered this because its not clear what you mean
David

Nov 13 '05 #2
I develop an access database with forms and VBA modules.

When I deliver this database, I would like that the users cannot
access to the code of these forms and modules (to avoid accidental
modifications).

So, before making the delivery, I protect the code by setting a
password to the VB project (properties protection tab). I do this on a
copy of the .mdb file, so as each time I develop I do not have to
enter the password to make modifications.

This is a very simple task, but since I use a VBScript script that
performs some
other tasks necessary for the delivery, I would like to include this
task in the script.

Since we can access to the VB project by automation with code like:
Set db = GetObject("DB.mdb)
MsgBox db.VBE.ActiveVBProject.VBComponents(1).Name

I am wondering if I can perform this password protection of the VB
project by automation.

Hope it's clear.

David.

d.***************@blueyonder.co.uk (David Schofield) wrote in message news:<416317e7.1041876699@localhost>...
On 4 Oct 2004 02:39:07 -0700, la**********@yahoo.fr (David LACASSAGNE)
wrote:
Is it possible to set a password to protect the code of an Access VBA
project by automation (I already know how to to it manually)?

David.

Hi
I suspect no-one has answered this because its not clear what you mean
David

Nov 13 '05 #3
that's what MDEs are for... (or am I talking outta my ...?)
Nov 13 '05 #4
Pieter Linden wrote:
that's what MDEs are for... (or am I talking outta my ...?)


I'd agree but in some circumstances you may have designed an app where
it makes use of design features, e.g. building a form or report on the
fly, this would not be possible in an MDE. However, with a little
re-design...

--
Pretentious? Moi?
Nov 13 '05 #5

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

Similar topics

3
by: MissiMaths | last post by:
I have used outputTo to export a copy of a table out of access into excel. I was wondering if there is anyway to set a password on this within the code so that it is read only in .xls format? I...
1
by: Giganews | last post by:
I have an Access 97 database in which I am running an Excel macro through automation. The macro in Excel is as follows: Worksheets("Sheet1").Protect Password:="****", DrawingObjects:=True,...
15
by: Fady Anwar | last post by:
Hi while browsing the net i noticed that there is sites publishing some software that claim that it can decompile .net applications i didn't bleave it in fact but after trying it i was surprised...
11
by: sweetpotatop | last post by:
Hi, I wonder if it is possible to read the content of an excel spreadsheet through aspnet. The spreadsheet (workbook) is protected and it resides in a network drive. Please provide sample...
22
by: teejayem | last post by:
Hi, I am new to programming with databases and was wanting some help. Is there any way to password protect an access database and access sent sql commands to it via vb.net code? Any help...
0
by: Sharath | last post by:
Quality Globe is Glad to Offer you the Fast Track course on Automation, QTP Basics and Advanced, and Quality Center Starting Date: June 4th, 2007 Timings: 10 AM to 3:30 PM Duration: 50 Hours ...
0
by: Sharath | last post by:
"Inspired" by the huge success of our first two automation fast track batches We are forced to start third fast track automation batch ...
0
by: Sharath | last post by:
We are glad to inform you that "Inspired" by the huge success of our first three automation fast track batches We are forced to start fourth fast track automation batch ...
0
by: Sharath | last post by:
We are glad to inform you that "Inspired" by the huge success of our first four automation fast track batches We are forced to start fifth fast track automation batch ...
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
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.