Disable Import and Link

[kyoch]

All,

Is there a way to disable the ability to Import and Link the BE of a database?

I've added several security measures to the FE and BE but all the information in the BE is still easily accessible if the user makes a new database then links or exports the tables. Can VBA disable some of the export/link properties of BE?

Password protecting the BE doesn't work because that limits FE user's ability to work with the database.

Unless......there's a way to program the password of the BE into the AutoExec macro in the FE. Suggestions?

 

[Ranman256]

If you have a form ,
and a button to 'get' data via linked tables,
why would a user go around the system, when all they have to do is click 1 button?

 

[kyoch]

The FE only allows users to 'get' data via reports. I don't want users to be able to easily copy the BE data and save into excel.

 

[kyoch]

I'm guessing this type of security is not possible?

 

[kyoch]

https://www.youtube.com/watch?v=OXrwumT3JUo

Simple.