Discover if another DB links to tables in my DB

[TriciaPreuss]

Hi:

Is there any way to tell if another DB links to a table in my DB? I created a table for another user to link to, and only want him to access that table. However, I'm afraid he will go into the other tables. I want to see if he's created the link to that table only. I appreciate any replies!

Thanks.
Tricia

 

[jsteph]

Use Access security and just block access to the tables.
--jsteph

 

[willir]

TriciaPreuss

Another way, without invoking seucrity, is to disconnect the table in question from your database.

The Shift Supervisor needs to access the phone number of employees.

The HR manager has the information in their database along with salaries. Obviously, HR does not want the supervisor to access this sensitive information.

Names and phone number tables split off from the HR database.

Shift Supervisor Contact database links to the tables in the Name&Number database only.

The HR has their own database, but now links to the tables in the Name&Number database for the employee contact information. The salary and personal information is protected.

Richard

 

[TriciaPreuss]

Thanks for those suggestions. Here's another question - is there any way to tell if someone actually opens up the backend of the database? My DB is split into a backend and frontend. Due to the nature of the network, the b.e. must be on the same drive as the f.e. I've hidden the b.e. so the users can't see it (unless they have the show hidden attribute in explorer on). However, someone unhid it somehow. Is there some way to tell who unhid it? Thanks!

 

[willir]

TriciaPreuss

With the older Microsoft security, you can only use the hidden file attribute. Novell is better at this kind of thing where you can control file and dreictory attributes and security far beyond this where the windows Explorer setting can not circumvent.

I am not sure about the new Windows Active Directory which, in some ways, seems to be similar to Novell.

Per determining if a user is access the backend directly, only way I am aware of is to really control this is with invoking Access security.

Again, Novell will show who last accessed a file, but with a database this is not a real useful statistic.

You state that the back end and front end have to be on the same drive. This is too bad since it limits your control on network security. You may wish to re-evaluate this, or at least break things down a bit...

N:\DB\ContactInfo (shared table)
N:\DB\SecureDB (database with protected info)

Your person in question can only access the databases - his and the shared tables. You can access the secured DB plus the Contact DB. Security is setup using whatever network security you have in place.

Richard