prevent viewing of sql tables

[bembden]

Hi

I am a novice so bear with me. I am responsible for a sql database with an access front end. I have a user that goes directly into the sql tables from his computer and modify them. Can I prevent him from seeing these tables?

Thanks

Bernie

 

[checkai]

How does he connect to the tables? Through Enterprise Manager? Authentication method?

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[Juice05]

I bet they are linked tables directly from access to SQL Server via the linking manager am I correct? Because of this you should compile an executable from access and give him that rather than allowing him access to the .mdb file.

 

[bembden]

The database is avaliable over a Citrix environment. The access front end links to the sql database.

Bernie

 

[Juice05]

You need to make an .mde file instead of allowing access to the .mdf. When they have access to the .mdf they can makes structural changes to the database. The .mde prevents this from happenening.

 

[bembden]

Windows server authentication

Bernie