Link Table Permissions

[MikeC14081972]

Is there a way in Access (TableDefs or the like) where by you can set a property of a table to stop it being linked to from another database?

Thanks

If you make something idiot proof - They'll Only make a better idiot!!!

 

[LNBruno]

Yep.

Right click on the tablename in the database window. Click properties. Check the "Hidden" check box.

To see it again, click the Tools menu, then click Options, then the View tab. Check the "Hidden Objects" checkbox in the "Show" section.

The properties of the table will still have "Hidden" checked, but the Tools Options setting overrides it. You'll need to uncheck "Hidden Objects" for it to be hidden again.

< M!ke >

 

[MikeC14081972]

Many Thanks.

Hidding the table makes sense so other Db's wont see it.

Thanks Again.

If you make something idiot proof - They'll Only make a better idiot!!!