Disabling the Bypass Key on Startup

[Guest]

I have an .adp project that accesses SQL Server. I want a customized version
to prevent users from changing form/macros... So, I modified the Startup
options (Tools/Startup) so that the user was presented with only the features
that I wanted them to use.

However, they can bypass the Startup options if they hold down the Shift key
when they open the .adp file. I read that the Bypass key can be ignored by
setting AllowBypassKey = False. However, there is no code snippet to show you
how to do this when working with a project file (there is an example for an
..mdb file and there is some obscure references to Properties in a
CurrentProject object). I know that a macro named Autoexec should call
(RunCode) a function that sets this property in VBA.

What's the best way (code snippet if you have it) to prevent a user from
bypassing your startup options or securing your interface when using an .adp
project

 

[Sylvain Lafontaine]

The Properties are programmed in a different way with an ADP file than with
an MDB file. I will try to find some old pieces of code about that but
obviously, any piece of code setting the AllowBypassKey property for a MDB
file won't work for an ADP file if you don't make the necessary adjustment.

However, even for a MDB file, the AllowBypassKey property can easily be
by-passed. You only secure option is to convert your ADP file to an ADE
file.

S. L.

 

[Guest]

What I really want to do is prevent design changes to the client application.
From what I read, converting to an ADE file does not prevent design changes
to forms, reports... How can I distribute an Access project (SQL Server)
where the forms, reports and code can't be modified?

M

 

[Sylvain Lafontaine]

I don't know. My moto is: if your clients want to change things and screw
up everything; let them do it and later, send them the bill if they want you
to make the repairs.

S. L.

 

[david.bailey]

Actually, compiling the ADP into an ADE does prevent users from being able
to change forms, reports and code. All of these objects are compiled into
native code which can't be changed.
db

 

[sammy]

bro,

i just found this link on google:
http://support.microsoft.com/kb/826765/EN-US/

i think it will help you.

sam

 

[Jess Martyn]

Hi, Pal,

I have recently found a site which claims to be a
major competitor of big-dog Paypal.com

Site is www.greenzap.com/extreme This site is being
launched this summer,2005 on 1st June in full form,
but for now as advertisement strategy, they are
accepting registrations for their site, and you know
what registration is totally free and in addition to
that they are paying $25 just to register. And once
you register, you will have your own promo link like
www.greenzap.com/YOURWORD (like extreme is my word),
and anyone who registers with that link, you will be
paid $5 for each. But to register there, you need to
have a promo link,i.e. to be refered by someone.

So, i have signed up and increasing my community each
day, and I wish same to you.

- regards,
Devang.