Search results for query: *

Is it possible to administer a Windows 2000/XP server using MMC on a Windows 9x client? I've installed the dsclient.exe interface to Active Directory and the MMC 1.2 release on a Windows 98 machine w/o any success. Your help is much appreciated! Thanks, CJ

I appreciate the help. I just have several databases I'm trying to document and although I might be able to put the descriptions in on one, the others will require a lot of work. I'm trying to save myself the hassle of manually typing the descriptions for everything.

Yes, I've tried this and it works great w/one exception. It doesn't record my description, otherwise this is exactly what I want.

I've created a project using Microsoft Access. The program works great, but the database is rather large. I've been assigned the task to document my database, however I've already done this via properties of each field w/a description in the description property. I'm searching for software...

My table looks like this: PriKey as autonumber Str1 as string DateOfEntry as datetime Before I save data from my app., I delete all entries by date and subsequently add records as new. I don't just modify my entries by doing a search, I delete, then add new always. Can I recover data that was...

One other note. After delete, I have the "adAffectGroup" option.

Private Sub issueDeleteByStore(strTableName As String, strStoreCode As String) On Error GoTo errorMsg: Dim strSQL As String Dim lngCounter As Long Dim sqlRS As New ADODB.Recordset dbUtils.closeTbl sqlRS strSQL = "SELECT * FROM " & strTableName & " WHERE...

RJFost, I appreciate your help w/this, but I'm rather new to SQL. Would you help me w/a simple example of a delete option in a transaction? Thanks, CJ

In the below example, if I don't issue a 10 second pause after the delete query and attempt to add data w/o this pause, I get duplicate entries. It's like SQL Server isn't finished deleting data when I attempt to append. Am I doing something wrong? Thanks, CJ dbConn.Open...

Pweegar, Thanks - I appreciate your help. After I issue my .execute query, I do a simple while-wend loop making sure the recordset state is not currently executing code. The funny thing is, it's instant as I expected! I put a timer on my loop and it takes less than a second for SQL Server to...

I've written a VB 6 application that checks for the existence of a simple ASCII-based transaction files in a specific hard-coded directory and subsequently parses each file it encounters. After the file is parsed, it is moved to a "processed" directory. My ASCII-based files look...

I've written a Visual Basic application that checks for the existence of a simple ASCII-based transaction files in a specific hard-coded directory and subsequently parses each file it encounters. After the file is parsed, it is moved to a "processed" directory. My ASCII-based files...

I'm a little confused. We only have two domain controllers in our Windows 2000 (native mode) network and the settings for Account Policies|Account Lockout Policies are set to off. To do this, I set "Account lockout threshold" to 0. I just checked this value in 3 places: 1.)...

Windows 2000 Account Lockout: I setup Windows 2000 security a long time ago to lock out user accounts after 15 unsuccessful login attempts. One of my in-house users is experiencing constant lockouts, everyday after lunch, and I have to manually uncheck acct. lockout via Active Directory every...

I've developed an app. using Visual Basic 6 that utilizes the data environment w/an Access 2000 database. I have since setup a SQL Server replicating the Access schema. Am I allowed to connect my data environment to my SQL Server by just changing the data source? Is there any way to do this...

How do you disable account lockouts from happening? I'm having a similiar problem and I just want to disable account lockouts. Thanks, CJ

I have a user account that keeps getting locked out. A threshold was set a while back that after 10 invalid logins the account is locked out for 10 minutes. How do I disable this feature? I've set the threshold back to 0 but for some reason the user still periodically gets locked out. It's...

This may actually sound a bit silly, but I answered my own question. The following SQL works w/the above downloadable Access db. SELECT Store.StoreCode, Store.Store, M.ManagerKey FROM Store LEFT JOIN [SELECT StoreCode, ManagerKey FROM ManagerStoreAssoc Where ManagerStoreAssoc.ManagerKey =...

Example - http://mail.fat-tuesday.com/db.zip Change 2 to 1 and vice versa on QueryHelp for example --- I'm having trouble w/a many to many query. I have 3 tables setup. Table 1 = Store Table 2 = (many to many) ManagerStoreAssoc Table 3 = Manager Store has 2 fields: 1.) StoreCode (PK) 2.)...

I'm using MDI child forms. I have a MDI child form specified under Project|Properties. The problem is my program works sometimes. On occassion it will just hang. Any ideas?