Protect/Unprotect

  • Thread starter Thread starter QB
  • Start date Start date
Q

QB

I am wanting to create a utility to help with preparing to distribute a
database. I eventually want to be able to select the file and this utility
would:

Compile
Compact
Secure the Project from viewing by adding a password in the VBE
Disable the Shift Bypass

I also would like the ability to reverse the said operation when I need to
continue development.

Today I am inquiring about securing the Project from viewing by adding a
password in the VBE. How can I Protect & Unprotect a project from viewing
through code?

Thank you,

QB
 
I am wanting to create a utility to help with preparing to distribute a
database. I eventually want to be able to select the file and this utility
would:

Compile
Compact
Secure the Project from viewing by adding a password in the VBE
Disable the Shift Bypass

I also would like the ability to reverse the said operation when I need to
continue development.

Today I am inquiring about securing the Project from viewing by adding a
password in the VBE. How can I Protect & Unprotect a project from viewing
through code?
Click to expand...

It would be a LOT simpler to use a split database, with a backend containing
the tables and a frontend containing everything else. You would keep your own
private copy of the frontend in .mdb (or .accdb) format, compile and compact
it, set a startup form, hide the database window, define your own default
menus (or ribbon in .accdb), and convert the file to a .mde or .accde. THAT is
what you would distribute.

Note that Access Security is available for .mdb/.mde files but is no longer
available for .accdb/accde format databases.
 
You know you are in the Excel Programming area, right. What you described is
EXACTLY what Access does. I don't think you can even do some of the things
that you described in Excel (Compact, etc.)

If you try to Force Excel to do the othr things, you are going to create
constant headaches for yourself. Spend the $$$ for Access, and spend a
little time getting acquainted with that tool, and you will be much, much,
much better off in the long run.

Good luck,
Ryan---
 
Oh! So sorry, I was toggling back and forth b/w the Excel Programming group
and the Access Programming group; I thought I was in the Excel Programming
group when I posted that comment. Sorry, sorry, sorry… It’s been a long
day, and only half over…
 
Oh! So sorry, I was toggling back and forth b/w the Excel Programming group
and the Access Programming group; I thought I was in the Excel Programming
group when I posted that comment. Sorry, sorry, sorry… It’s been a long
day, and only half over…
Click to expand...

Ya better go down to the Malt Shop and have something tasty and cool... <g>
 
Back
Top