table persmissions with msaccess 1

[Machiaveli]

Hello,

I need some help with implenting the following:

I recently migrated from access to sql server and i now i want to use maintainable permissions on my tables, views, etc. The access database will server as a front-end.

I've created for testing purposes an testaccount with only a public role to access to my database.

Now the hard part is when i want users to select and manipulate the data, i want only permissions set on views and stored procedures. The reason for this is because i don't want users to get the data directly from tables by means of linking or importing them to access databases. Only views and stored procedures can be used.

Unfortunelately it doesn't work how i wanted to. When i open a view which is linked in access as a table, i'm getting a message that the underlying table has not the appropiate permissions.

Now there should be a way to apply a maintainable security, so if i could have some advice on this i would be very thankful.

 

[mrdenny]

Your security model should work nicely. However using access as a front end is going to really monkey with everything. Access tries to "help" by looking directly at source tables of views, which as you have noticed it won't be able to do, because you've removed the access to those tables. You might want to look at ASP for the front end to help you implement the security you want to use (which is my opinion is the best way to setup the security).

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[Machiaveli]

Hi mrdenny,

Thnx for your insight. If it isn't possible to use acces as a front-end for my security model then i shall look at asp pages.

What do you recommend what i should need. I never worked with asp and i have no clue what requirements i need on the server and client side.

Could you provide me with some more info?

Thnx

 

[mrdenny]

For the client side all the person will need is a web browser. For the back end, you'll need some sort of web server. IIS running on Windows 2000 or Windows 2003 will work perfectly for this.

ASP is basically VB Script, so it's vairly easy to learn. Most any of the books out there will work for you. The trick to picking a book, is finding one that is written in a way that is easiest for you to read.

Denny

--Anything is possible. All it takes is a little research. (Me)