To test this out, I create a job 'AddUser' which just contained the code sp_addlogin 'test'.

Not sure whether it is possible to use SQL-DMO in Access 97 so I tried...

Thanks for the replies so far.

I don't want to give access to all security, only execute access to procedures within a single database plus anything else they need to get...

Andy, sorry my terminology was confusing. When I referred to users, I really meant the individuals who will use the database.

Currently I store all individuals in a table: Id, name,...

These are actually SQL Server logins, I found that NT logins work to slowly on our WAN.

Regarding your second suggestion, if the user adds a user id to a table,...

I spoke to soon.

Within Access the procedure does not work because the user is not a member of 'the sysadmin and securityadmin fixed server roles'

Is there a workaround. I am...

Silly question - it was all much simpler than I thought:

--Add a user

DECLARE @Result int

EXEC @Result = sp_addlogin 'test1', 'test'

EXEC @Result = sp_grantdbaccess 'test1'

EXEC @Result = sp_addrolemember 'kbuser', 'test1'

--Delete a...

Just to make sure I understand, Frank says "I've never had orphaned logins". Does this mean the logins transfer OK if the SID does not already exist on the...

quote:

---

Code should work about the same.

---

I was thinking more about how I would need...

Excellent, now all I need to work out is how I can use these examples within stored procedures together with error checking so that I can manipulate logins and role...

Many thanks for the replies.

Does this mean that if I use the DTS wizard to export from a source database to a destination database on a new server, and select the "copy objects &...

Many thanks for the replies.

I am a bit new to SQL Server so excuse the dumb questions.

Tried shamshad solution which did the trick. Just a case of running for...

Andy, thanks.

I suspect that I might end up moving a zipped file and then using DTS but I guess might go down the zipped file route. I was hoping...

Thanks for this suggestion, and I may end up trying this in the longer term.

In the shorter term however, the Access program with the data to be uploaded is running...

OK a little clearer but still a bit muddy.

When Access opens it is using ODBC. Looks like each SPID number has a login and loginout depending on activity and there...