Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Preventing database importing?


Message #1 by "Sam Roberts" <samuel.roberts@h...> on Tue, 26 Nov 2002 16:06:05
Hi,
I have now got my Access 2000 project very well secured (or so I thought). 
However it is very easy for people to import EVERYTHING into another 
access database. Obviously this is far from ideal. Does anybody have any 
tips on preventing people from importing objects from my otherwise secure 
database?
Thanks in advance,
Sam
Message #2 by "Derrick Flores" <derrickflores@s...> on Thu, 28 Nov 2002 01:03:50 -0600
Sam,
I would suggest looking into creating a custom menu and toolbar and also
change your startup options to prevent any Menu/Toolbar Changes.
if that doesn't work for your pesky users then what I would do is to create
a Macro and name it AutoExec
And in this macro it will run a Function "CheckUser()" in the Modules
section.
In this function you would check who is log onto the computer or you can
check the name of the computer.
Once the verification is done, you can write some VBA that will change the
Startup options automatically.  Especially when the user cannot use
the special key "Shift" to bypass your Autoexec.

Good Luck,
Derrick Flores
San Antonio, Texas

----- Original Message -----
From: "Sam Roberts" <samuel.roberts@h...>
To: "Access" <access@p...>
Sent: Tuesday, November 26, 2002 4:06 PM
Subject: [access] Preventing database importing?


> Hi,
> I have now got my Access 2000 project very well secured (or so I thought).
> However it is very easy for people to import EVERYTHING into another
> access database. Obviously this is far from ideal. Does anybody have any
> tips on preventing people from importing objects from my otherwise secure
> database?
> Thanks in advance,
> Sam



  Return to Index