Disable Import and Link (1 Viewer)

kyoch

Registered User.
Local time
Today, 08:45
Joined
Mar 5, 2014
Messages
58
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

Well-known member
Local time
Today, 09:45
Joined
Apr 9, 2015
Messages
4,337
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

Registered User.
Local time
Today, 08:45
Joined
Mar 5, 2014
Messages
58
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

Registered User.
Local time
Today, 08:45
Joined
Mar 5, 2014
Messages
58
I'm guessing this type of security is not possible?
 

Users who are viewing this thread

Top Bottom