Search results

Do I just replace the line: DBCC DBREINDEX(@TableName,' ',90) with: DBCC INDEXDEFRAG (@TableName,' ',90) and run the same code, just with it off-line?

Well, now when I reboot the server it still takes 8 min to run, so now that is not even fixing things!! Is there a way for me to completely rebuild the indexes and statistics and whatever else on all my tables all at once. If so how?

The server has 2% free disk space, which is about 800 meg on this disk. And since I don't know how to empty the log file, I will say that I never have empted it. :o (How do I?)

But shouyldn't the nightly reorg "fix" that? Also, is the 10% setting OK? I'm not real sure what that means, but it was the default.

A few things, but it is a quad processor and when I look at it nothing is being taxed much.

I have a stored procedure that normally takes 1-2 seconds to run. However, after a couple of days, it then takes 7-8 minutes to run. The tables are not being heavily modified. If I stop the SQL server and its service then start it again and run the same stored procedure, it runs again in...

Yes, I agree, but i don't get to modify the tables, just my code.

What is the syntax for telling me what current record I am on in a record set using ADO? In DAO it is rst.CurrentRecord, but I can't seem to find the equivalent in ADO!! Old DAO code: 'If Me.RecordsetClone.BOF = False Then ' Me.RecordsetClone.MoveFirst ' ' For i = 1 To Me.CurrentRecord...

Here is the final way I exported my embeded docs. I could not find a way to make it completely automatic but had to put a button on a form and click on it for every record, but at least it was only one click. I have attached the sample database (Access 2000) if you make any adjustments please...

I am getting closer. I could not find a way to open the embeded file without a form being open (still want to do it just in code and a recordset). What I have now is a form with one button on it that runs this code. But it stops because it sayd there is no document open. I think I have to...

I am trying to do the following: 1. Loop through a table of embeded Word docs 2. Open each one 3. Save it as a file 4. Close the file 5. Loop to the next one Here is my looping and opening code that is not working. Dim rst As New ADODB.Recordset Dim strTableName As String Dim ctl As...

Thank, but no thanks. ;) That is not an option since the double click code in my menu would then open ALL the forms in data sheet view, not want I want.

I have a main menu that I select things to open. Most of the things I open I open in form view but some I want to open in data sheet view. Without recoding my menu code is there a way to specify in the form to be opened that it should open in data sheet veiw? Right now I have the default view...

I converted a form and its queires from Access MDB to ADP and I can't get my form to show the footer calculations anymore. The underlying query has two fields that are sumed that I want to do a calculation on. sum(dbo.vProcMgrTotalFeetPerWOID_ByShift.TotalFeet *...

I need to select 200 random customers from my table, how can I do that? Table: tblCustomers PK: CustID

Yes, I have used the viewr before. I just might try that. Now, if I can just get them out of the database and saved as files!

I have some ADO code that I am trying to convert to ADO and I am getting stumpt on converting this line: rstTblFill.FindLast "[Equip] ='" & strCurrLine & "'" I tried using just: rstTblFill.Find but that takes me to only the first occurance. And "MoveLast" takes me to the end of all the...

If use the following code it works: Dim rs As New ADODB.Recordset Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection rs.Open "T_Schedule_ProductionItems", cnn, 3, 3 'read write = adOpenStatic, adLockOptimistic 'read only would be...

I thought you were supposed to take that out when using ADO? When I put it back in (I had it originally in the old code) I get an error: "Method or data member not found"

I am converting from DAO to ADO in Access 2002 and using MS SQL2000 for my back end and when I run this code I get the error for the line I have colored red below; "Current recordset does not support updating. This may be a limitation of the provicer, or of the selected locktype." The table is...