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

 

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@gmail.com [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: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

---

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 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___