How to prevent clients from linking to a back-end db?

[Tore]

Hi.

client - server - access - security

Access 2000

The client computers in a local network have have access 2000 installed on their computers.

I want to install an .MDE file on each client from where they can access data from an .mdb file on a server.

The .MDE file are linked to the tables in the backend-db.

What is the best way to prevent the clients to connect / link to the backend-db from other apps than the distributed .MDE file?

I do not want them to be able to, let say, create an empty DB in access 2000 and then link to the backend.
I do not want them to be able to link / connect from excel, word etc.
Not from any other app...

Is that possible and how do I make sure it will work.

Anyone with and answer to this?
Any link to tutorials would be nice.

Regards

 

[jsteph]

Firstly, if the backend uses proper Access/Jet security, they shouldn't be able to link in the first place.


But to get more elaborate, check out my response in this thread:
thread181-1286489

In a nutshell, you hide the backend location, even the front-end location, and call the front end via a shell call within a tiny .exe file that you create in VB.
--Jim

 

[Tore]

Thanks for the feedback.

Appreciate it.