[AccessD] Stopping import of tables and queries from mde

Fred:

Table structure's not too important. It would be nice to hide.  But the text 
is in a memo field.

Rocky

----- Original Message ----- 
From: "Fred Hooper" <fahooper at trapo.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, September 22, 2005 10:49 AM
Subject: Re: [AccessD] Stopping import of tables and queries from mde


> You can replace the queries with SQL code (copy/paste from the query 
> viewed
> as SQL, treating the quotes properly), modified to provide whatever inputs
> the queries need direct from the code. I've done that a lot, and for a few
> critical cases where I needed to chain complicated queries together, I
> create them when they're needed from code, grab the results, and delete 
> them
> before displaying the results. (It doesn't take much time.) It's still
> possible get around this, but unlikely.
>
> If it's the data in the tables that's the issue, you could encrypt the
> critical fields -- lots of ways of doing that, but most will require text
> fields (you could code in the numerical type as part of the encryption, if
> you needed to).
>
> If the table structure is the issue, I doubt there's any way of hiding it
> other than treating them like the queries above (creating from code what's
> needed and then deleting it).
>
> Fred
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Thursday, September 22, 2005 1:02 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] Stopping import of tables and queries from mde
>
> Dear List:
>
> I have an mde which is going to be distributed as a consumer product
> (Wise/Sagekey install).  However, I see that even though I thought I had 
> the
> mde all locked up, anyone with Access can still import the tables and
> queries.
>
> Is there a way to prevent that without causing problems in the product?
>
> MTIA,
>
> Rocky Smolin
> Beach Access Software
> http://www.e-z-mrp.com
> 858-259-4334
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>