The easiest way, if you don't want to get involved with user-level security or password protection, is to hide your objects. Right click a table or query, select properties, check the "Hidden" attribute. To show hidden objects in your db, select Tools --> Options and check the "Hidden Objects" checkbox in the "Show" section. Hidden objects won't appear in the Import or Linking dialogs, though they can still accessed via code. For example, one could still use ADOX or DAO to retrieve a catalog of table schema information that would list your hidden tables as well. But hiding objects provides some modicum of security. To really lock down your data objects though, you'd need to follow peko's suggestion and implement user-level security.
Bob
|