Hoping for a bit of advice on how to create SQL 2000 users through an Access Front End. I'll tell you how far i've got.
I've created a VB
Procedure that executes sp_addUser stored procedure,with assigned Parameters(e.g UserName,Password).
Now I can successfully add the User, assign it to the correct Group only when I logon as a User who has the System Admin Privilege. I obviously don't want to give this Privilege out, but then I would still like the capability to allow other users the right to create users to the Database, without relying on me.
Before the user gets to the Create Logon screen, I also want to query whether the CurrentUser has privileges, if not then stopping him getting to restricted screens.
Any advice would be much beneficial