Using correct Store Procedures in Access

[Goondu]

Using Access 2000 with SQL Server 2005 Express.

I can create a routine to add/drop users and add/drop logins with store procedures.

However, I could never find a way to allow users permissions with db_dataread and db_datawrite with a database. I could not google up any search on these or maybe I need help with the search?

I tried using sp_addrole and sp_grantdbacess, both failed
-2147217900 The login already has an account under a different user name.

So, does anyone know the correct store procedure to use or set of SP to use? Or anyone knows a good web site on how to address this problem?

Thanks

 

[TheBugSlayer]

The error message suggests that the user already exists. You may find this discussion useful:

http://social.msdn.microsoft.com/fo...y/thread/9faf79d0-f4b6-4b6c-9505-68cd2ec636af

In case you' re wondering, I just pasted your error message in the Google search box...

Good luck.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)

 

[Goondu]

Thanks TheBugSlayer,

But that not what I intent to do. Sorry about the error message, it wasn't the problem.

My intention to Access as a tool for creating users instead to SQL Server management tool.

The process will be the Access as a front end application.

Will GRANT work? I mean granting access to the tables.