Re: [MS_AccessPros] Re: How create the file to be distributed

 

crystal, John,

thank you for the useful suggestion

my goal is avoid that some Expert user can see inside ODBC table without any filter

Valentino

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

adding on ...

if renaming to preface with usys is not an option, you can right-click an object in the Navigation Pane, choose (Table) Properties, and check the Hidden box. But as John said, this will not stop a savvy user who is determined, which is usually not an issue. 

If your database is split into FE (front-end) and BE (back-end), another thing you can do is rename the Access back-end so it does NOT have an accdb extension (no reason to turn BE with only tables into ACCDE).  This helps if a user double-clicks on a file from Windows as, without expected extension, Windows will not know how to open it.

>> the tool of BILL can in some way also used to delete all

this properties  and go back to original condition and make the table visible again. <<

no and yes -- 'no'  to delete the properties, but 'yes' to Bill's tool to change them again. Since previous messages on this thread are gone (please be sure to enable option to keep them), here is the link to Bill's Properties Setter tool:

http://www.thatlldoit.com/Pages/utilsaddins.aspx

you will find the source code for this tool if you download it from the Files section in MS Access Professionals, where it is also posted.

respectfully,
crystal

http://www.MsAccessGurus.com
connect to me, let's build it together
 
~ have an awesome day ~

On 7/6/17 10:04 AM, John Viescas JohnV@... [MS_Access_Professionals] wrote:

Valentino-

I'm not very familiar with Bill's tool, so I don't know what specifically you have done.  Beyond setting the AllowBypassKey property, disabling Access special keys (like F11 to show the Nav Pane), and providing code to hide the Navigation Pane on startup, I'm not sure what else you could do to "hide" what's in your database.  I suppose you could make all tables "hidden" by starting all table names with "USys".  But anyone with "expert" knowledge could open your database in code from another database, look at and modify all the properties, and reveal all the objects.  The only other thing you could do is to put the database in a Windows secured folder and allow only authorized users to get at the database.

John Viescas, Author

Effective SQL

SQL Queries for Mere Mortals 

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

http://www.viescas.com/ 

(Paris, France)

On Jul 6, 2017, at 11:06 AM, valentino.avvisati@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Hello to All,

I used the tool  of Bill and is working  perfectly 

I also transformed the file to be distribute to an ACCDE

and I think is quite safe,  but the tool of BILL can in some way also used to delete all this properties  and go back to original condition and make the table visible again.

I would like that the table cannot be visible especially the ODBC.

is this possible?

The transformation of the file to ACCDE  make the code compiled and not visible and is one way direction transformation, if you need to change the database you need to work with the original ACCDB and is ok.

   my issue is avoid that some expert  that want to go deeper and open the ACCDE  database and see the table and also the ODBC table 

any suggestion?

thank you 

 

__._,_.___

---

Posted by: valentino.avvisati@gmail.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (8)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___