My Assistant
Site Message
(Message will auto close in 2 seconds)
 How Unsecure Can You Possibly Get?, Office 2007
|
|
 Feb 25 2012, 12:56 PM
Post
#1
|
|
|
UtterAccess Member Posts: 36  |
I have been reading for about two weeks on how to secure a database. all the tips provided combined gave me the ultimate solution...except for one tiny detail:
how do i stop someone from importing a table or query from a database (access 2007)?! For those of you who put passwords in tables you can forget it, its pointless. unless you have a different way of securing the database that you really haven't shared with anyone. How can I stop a user from importing from a database, table, queries, structure, etc. making an accde does not stop the import of tables and queries only forms, reports, mod etc. |
 |
 
|
 |
Replies
|
Feb 26 2012, 01:41 PM
Post
#2
|
|
|
UdderAccess Admin + UA Ruler Posts: 15,649 From: Upper MI |
"Security by obscurity" is about the best you're going to get with a pure Access solution. As an alternative, you could use SQL Express to provision tighter security for your back-end.
|
|
|
|
Posts in this topic
Surendra87 How Unsecure Can You Possibly Get? Feb 25 2012, 12:56 PM
theDBguy Hi,
Not sure if this will help in your quest but ... Feb 25 2012, 01:05 PM criquio I use to divide my apps into backend and frontend.... Feb 25 2012, 01:35 PM Surendra87 still fallible...
not good enough. Feb 25 2012, 01:37 PM Surendra87 well having everything in vba is probably one way.... Feb 25 2012, 01:41 PM theDBguy Hi,
QUOTE (Surendra87 @ Feb 25 2012, 11... Feb 25 2012, 01:42 PM theDBguy QUOTE (Surendra87 @ Feb 25 2012, 11:41 AM... Feb 25 2012, 01:45 PM Surendra87 i am trying to prevent the user to do this:
open ... Feb 25 2012, 01:47 PM theDBguy Hi,
QUOTE (Surendra87 @ Feb 25 2012, 11... Feb 25 2012, 02:05 PM criquio Here you have a way of hiding or showing tables an... Feb 25 2012, 02:06 PM jleach There really is no way to do what you're looki... Feb 25 2012, 04:47 PM Surendra87 whats the difference between the code and right cl... Feb 25 2012, 05:26 PM criquio When you hide it by right clicking it you can stil... Feb 25 2012, 05:46 PM Surendra87 Ah! I see what it does!
well thats nice. ... Feb 25 2012, 06:32 PM jleach Just for the record, I'm pretty sure that even... Feb 25 2012, 06:43 PM criquio I made an example:
http://dl.dropbox.com/u/545450... Feb 25 2012, 06:51 PM Surendra87 it could work for now...i guess, cause in order fo... Feb 25 2012, 06:57 PM theDBguy Hi,
QUOTE (Surendra87 @ Feb 25 2012, 04... Feb 25 2012, 09:10 PM Surendra87 False sense of security... Ha! Funny. There is... Feb 26 2012, 07:55 AM theDBguy Hi,
Like I was saying earlier, Access is a file-b... Feb 26 2012, 11:18 AM jleach Here's something to read. How Unsecure Can Yo... Feb 27 2012, 08:17 AM
jwild Security in Access is long dead - get over it. Feb 27 2012, 11:37 AM |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 18th May 2013 - 07:39 PM |