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'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...

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...

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...

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...

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...

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...

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 having an unusual problem w/an application I've written in VB 6 (SP5). It uses MSADO 2.7, Crystal Reports 9, and connects to an Access database (2000). When my app. first starts, it literally just hangs. If you get into task manager, you see the app. name as running, but you don't see it...

I'm trying to write an ANSI SQL statement to pull data from three tables in both Access & SQL Server. I'd like to create one ANSI SQL statement and use it both in Access and SQL Server 2000. My three tables are Inventory, GLACNT, and APVEND. I want all data from my Inventory table w/outer...

Does anyone know how to change the .Connectionstring property of the Data Environment through VB code? I have tried to change it directly by doing a DE.ConnectionObj.Connectionstring = &quot;<connection string>&quot; but I get a new .Connectionstring to the effect of the old string w/a value...

I wrote an application using VB 6 and the Data Environment. My variables are declared as @Variable in my SELECT statements. I am using the same schema on my SQL Server and when I attempt to connect to SQL I get errors. I have read that I need to use ? as my variable names in my SQL selects...

I wrote a Visual Basic 6 application that works great w/Access using the data environment. I want to port my existing app. to work w/SQL Server. I assumed it would be as easy as just changing my provider in my Data Environment to SQL Server. I have run into a problem w/my SQL variables. It...

I have been writing a Visual Basic 6 application to use Microsoft Access 2000. It works great. I have recently installed MySQL and migrated the Access data to MySQL. The database schemas are the same. I went into my Data Environment Connection object and changed from Jet 4.0 to ODBC using a...

Is it possible to connect to an Access database via a web application (an Active X Document EXE) running through Internet Explorer? Basically I just want to have my clients connect to my *.mdb file via Internet. Is this possible? I am using the Data Environment. Currently I have specified a...

I'm just about finished writing an ActiveX Document EXE app. I want my users, who connect via Internet off-site, to be able to access a local Access database for transactions. Can I do this w/an ActiveX Document EXE? Locally my users connect fine, but they have static drive mappings. I'm not...

I am currently writing a &quot;Document EXE&quot; app. that makes use of &quot;User Documents.&quot; If a web user currently knows the URL of one of my user documents, they can see its contents w/o logging into the app. I want to disable this capability. Currently, I have a global variable -...