Search results for query: *

...net use G: "\\cristienas\Uranus\Windows\x86\NetWorker Clients\Version 7.6 SP3\networkr" /user:STROUD\<user> <password> "G:\setup.exe" /s /v"/qn /L*v """%TEMP%\networker_install.log""" The log shows failure: MSI (s) (E4:78) [16:36:20:843]: Attempting to delete file...

It's a bug in Windows 2000 - XP does it OK.

I have some vbscript for copying a file - it works fine when I double-click it. However, if I try to put it under control of the Scheduled Tasks (in Windows 2000) - the task runs indefinitely (and is never successful). I've tried recoding the vbscript (as a shell call and using .CopyFile). Same...

It was messed up around the 'go's I removed those and placed all the syntax on one line, it ran through fine and created the job. In fact all I wanted to do was run an existing job (so it was much easier then I thought :) Thanks.

I'm executing it through a bat file command: ISQL -u <user> -P <password> -d <Database> -i <the script above> -o <the log file above> It appears I can log on OK, but I see the syntax errors. Unfortunately I can't use QA to execute it (it has to be done from a Virtual PC without SQL Server...

...this: BEGIN TRANSACTION DECLARE @JobID BINARY(16) DECLARE @ReturnCode INT SELECT @ReturnCode = 0 IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'Database Maintenance') < 1 EXECUTE msdb.dbo.sp_add_category @name = N'Database Maintenance' IF...

Thanks very much - that first excellent link did the trick. I used ReadBinaryFile(cFileToSearch) to read it and RSBinaryToString(xBinary) to convert to a string. It's fast (5 seconds).

The idea of searching by line is a good one - and in fact all I'm interested in is whether the string occurs (not how many times). I've done that and it works fine - the problem comes if the file is binary (I then get the message &quot;Input past end of file&quot;). Big text files are fine...

That's interesting. Nearly *all* of the time is spent reading the string in.

It was taking about 3-4 minutes to find 3 occurences in a 1,230 KB file, which did not compare with a UNIX grep at all well! I've not tried the Instr() approach.

Thanks - I've given up on this approach. It will &quot;work&quot; as long as the file is text - but it's too slow.

I'm using this code to find a string in a file. It works fine as long as the file is NOT a large binary file!! Unfortunately that's exactly what I want to look in. Any ideas what the problem might be/solution. Thanks in anticipation. Option Explicit Dim objRegExpr Dim FSO, TF, inp Dim...

This is just an example, the following code moves through the table called tbl and uses the field TABLE_NAME to step through each table's name (linking them to the database). You could adapt this as the key bit is the loop. Private Sub Command0_Click() Dim db As DAO.Database Dim rsTable As...

Remove duplicates from a table TEST. Step1: SELECT DISTINCT Tests.* INTO Tests_1 FROM Tests; Step2: DELETE Tests.* FROM Tests; Step3: INSERT INTO Tests SELECT Tests_1.* FROM Tests_1; Then get rid of the temp table tests_1: DoCmd.DeleteObject acTable, &quot;tests_1&quot;

I found WinZip's command line extension quite useful (then you're not limited to 8 char names): Dim myObjFSO Set myObjFSO = CreateObject(&quot;scripting.filesystemobject&quot;) CheckFolder &quot;C:\source&quot; Sub CheckFolder(strPath) Dim objFolder Dim objFile Dim objSubdirs...

Outline on how you might do with a simple example, Table1. You can use an ID in your table (an autonumber field): Table1 is: ID Field1 1 10 2 2 3 4 4 1 5 8 You can create a query that does this: SELECT [ID]+1 AS Expr1, Table1.Field1 FROM Table1; You can then create a join between your...

Many thanks - works a treat.

Please could anyone tell me how I can show the table that's currently being processed in the loop below. I'm trying to use a pop up form to show the name of the table being linked - only the pop up only gets the focus after the loop's done. Thanks. Private Sub Command0_Click() 'now do the...

If I use code it works fine though - strange: Dim db As DAO.Database Dim rsTable As DAO.Recordset Set db = CurrentDb Set rsTable = db.OpenRecordset(&quot;tbl&quot;) rsTable.MoveFirst Do While Not rsTable.EOF DoCmd.TransferDatabase acLink, &quot;ODBC&quot...

...However it executes twice - in fact it sometimes produces up to 4 instances of the tables! There's a lot of tables - so I use a Like &quot;ACC*&quot; to select all the ACC* tables. Can't see why. Any thoughts appreciated - may not be the best way to do this, but you'd think it would work.