|
 |
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
|
|
 |