Is the advice here to shrink and rebuilt the indexes? Will I need to alter tables and rebuild heaps?

First of all, I wanted to apologize for the multiple postings before. It was done by accident.

Okay. I found my answer to why the page_count and compressed_page_count do...

Right there with Babe,

This is exactly what I needed. Very nice coding, I will learn from this. Thank you very, very much!

All the best,

SQLSeTTer

Guess my question is, shouldn't there be 5 rows and not 7?

Thank you very much. Can you please explain to me the result table (MatchedLines) ?

The numbers need to match within the row and not within the set. I was hoping the identity would help with this but like I said, I'm struggling. ...

You replace what you had in there previously with what I gave you, correct?

Did you make both coding changes for Excel and Access? They both need to be in place.

replace this coding change to your Excel connection string and test. Leave the previous Access coding change in place.

-- Öffnen des Cursors und Export für alle gefundenen Tabellen durchlaufen...

replace this change to your access connection string and test.

-- Zufälliges Erzeugen eines Datenbank-Namens

SET @dbname = @pfad + CAST(newid() AS varchar(100)) + '.MDB'

-- Erstellen der Verbindungszeichenfolge

SET @conString...

Is this being run locally or you making a remote call ?

Its not a coding issue. You either need to rollback or roll forward your office builds.

Additionally, was the source server (F:\) office updated as well? There were drastic changes in Office 2003 to 2007. You will need to be on the same office...

It would have helped if you were to translate the German to English and you were using Access. I have taken the liberty to do the translation below.

Failed to...

Your question is not very clear. If you are curious about what the database name was, reading the header from the backup file is your best bet. Below...