sql database restrictions

[jlabre01]

Hi,

I wanted to know if it was possible to restrict access to specific forms on the access side once the database has been migrated over to the SQL server? I will link the access database to the SQL server so that we can still use the access setup, but the info will be stored in the SQL server. After the migration i wanted to know if it was possible to set limits on access to certain tables/forms for tables. password protection i mean.

jlabre01

 

[SQL_Hell]

In SQL server you can set permissions or in your case not set permissions to tables / views / stored procedures / user defined functions.

As for access forms the best way is to write something in VBA to lookup the users windows login and then compare to a list of allowed logins ect.

 

[Meltdown]

It is possible if your front end is a secured mdb file.

It's more work as you have to set sqlserver and access permissions.

 

[Banana]

Sure, but it doesn't have to be that complicated.

For example, if I'm doing to depend solely on servers' permissions, I simply require a login using a custom form for unsecured mdb/mde. They could open it but all they would see is definitions of the tables, queries, and form themselves but no actual data (at until they provided the credentials). Besides, you shouldn't have any sensitive data in your mdb/mde anyway.