Suppose I have an MS Access 2003 database called X.mdb. If I create a blank MS Access 2003 database, I could use the Import Wizard to import information from X.mdb to the blank database.If I password protect the VB code in X.mdb and deny the user access to the startup dialog box, I can prevent the importation of VB code from X.mdb. To import a module, a person would first have to remove the password protection. Is there a way to block the importation of certain tables, queries, forms, reports, or macros?When I give my database to my customer, I don't want them to import certain tables or queries from my database.

Testing to see if this post works. I don't like this new site.

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Okay, the Title text box is very distracting.

You can't limit tables in Access like this, nor I think in most other databases. You have to give the users some access to the data, and in so doing, they have a full range of activities they can do with the data, including exporting tables. This is why some developers either use obfuscated data, so even if they get it, they can't do anything with it, OR use a proprietary back end without providing an ODBC driver - unless a separate charge is paid.

If you really want to prevent your users from getting at their own data, you will want to use on of these other methods. I would bet lunch on that.

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com