Recent content by AccessSQLUser

Is there a stored procedure that will give me a list of all nt users. I know that the procedure 'xp_loginfo' will give me those nt accounts that are added to SQL Server but I need to get a list of all nt users in a domain.

Does anyone know how I could change the WSID of the connect string of the linked tables in my database to the current machine that is running the database? If I try to change it, it just reverts back to what it was before.

Thanks for the reply. I do have WSH installed but I get the error "Object doesn't support this property or method" by this line: For Each oUser In oDomain.Users

Ok, I'll try to describe what I'm trying to do. I would like to create a form in MS Access that will be a user-friendly way to add Windows NT users to SQL Server logins. I would like the end-user to be able to pick the NT USer that they wish to add using a combo box. My problem is this - how...

Ok, I'll try to describe what I'm trying to do. I would like to create a form in MS Access that will be a user-friendly way to add Windows NT users to SQL Server logins. I would like the end-user to be able to pick the NT USer that they wish to add using a combo box. My problem is this - how...

Anyone have any ideas?

I would like to copy all user stored procedures that I have in one database into another database but they should be encrypted. Is there a way to do this without creating each stored procedure separately and inserting the 'With Encryption' clause?

Right now I have a trigger that runs each time a record in Table1 is updated. This trigger basically inserts a row into a log table that I have in a separate database. What I would like to do is only insert into that table the values of the fields that were changed. Any ideas? My current...

I have a subform and I change the sourceobject of the subform based on a tabcontrol. There is definitely something buggy because sometimes my subform is not being updated. The actual sourceobject is being changed but many times the controls have nothing in them and then when I click around...

I have a subform and I change the sourceobject of the subform based on a tabcontrol. There is definitely something buggy because sometimes my subform is not being updated. The actual sourceobject is being changed but many times the controls have nothing in them and then when I click around...

Try this: Public Sub GetTableNames() Dim x As Integer For x = 0 To CurrentDb.TableDefs.Count - 1 Debug.Print CurrentDb.TableDefs(x).Name Next x End Sub

Did you try exactly what I posted or does your query include other syntax too? If it does, please post your whole query?

Try this: Select [ClientDetail2].[ContactsID] From [ClientDetails2] Left Join [Other Table] on [ClientDetails2].[ContactsID] = [Other Table].[ContactsID] WHERE [Other Table].[ContactsID] Is Null

Try this: WHERE ((([BQualify].[Category])=forms![formname]![Combo62]));" and if that doesn't work try Dim myString as string myString = me.Combo62 me.recordsource = "Select....Where ((([BQualify].[Category])=""" & myString & """));"

I believe that this is happening because you cancelled the update event of the form (docmd=cancelevent). To get around this, you can put 'docmd.setwarnings false' before that line of code. Just remember to set it back to true afterward.