Preventing Links to SQL Data

[GeekGirlau]

I've been given the task of providing recommendations for upgrades to an Access 2003 database that links to SQL Server data.

I have one user in particular that is bypassing the Access application and creating his own, directly linking to the tables. What I want to do is allow read/write permissions if he logs into the Access application, but prevent him writing to the data (or preferably connecting to it at all) if he tries to bypass the current application.

I'm not a SQL Server developer, so am looking for advice re security. The long term objective is to redevelop this application down the track, but for the next 12 months it will have to remain in MS Access.

 

[BNPMike]

Can't you just ask his boss to sack him if he doesn't do as he's told, or just deny him all access until he agrees to behave?

I'm no SQL Server expert but I would have thought you could assign users rights to a view rather than base tables. That view could incorporate processing to prevent improper access.