Ok, but was is the script? BCP, T-SQL etc.....

How did you try to export the data with a scheduled job? I mean BCP etc......

Some sample code from you would make this easier however, it goes something like this;

UPDATE Table SET Column = T.Column

FROM TempTable T INNER JOIN Table X ON T.Pkey = X.Pkey

WHERE...

SELECT ColumnA, ColumnB

FROM TableX A

WHERE NOT EXISTS( SELECT * FROM TableY B WHERE A.SSN = B.SSN)

OR

SELECT ColumnA, ColumnB

FROM TableX A

WHERE A.SSN NOT IN ( SELECT SSN FROM TableY)

I'm sure other who have VLDB's will add to my list!

(A) Maintenance! For VLDB's, you will have to find a window of opportunity to perform Database Maintenance as it will...

It's possible that the Mapi.DLL could be corrupt! Don't take my word for it, I'm just going throught he elimination process in my mind and scene as though you have...

Am I missing something here? Correct me if I'm wrong but to solve this, wouldn't you just have to increase the VARCHAR(36) Column to VARCHAR(38) or perhaps VARCHAR(40) to be...

If you have placed UniqueIdentifier COlumns on all your tables then Merge Replication will not duplicate that! However, it will put UniqueIdentifier Columns on your lookup tables as well. Don't...

More info is needed! Was there any errors? Show us your code!

Shouldn't you be able to just update the row from Access to SQL Server via Linked Tables within Access?

The Index is corrupt!

Perform a consistency check on the Database and then either perform a DBCC DBREINDEX or DROP it & Re-Create it, then perform the delete operation again!

Landrake,

Avg. Pages per Extent........................: 8.0

Implies that there are 8 Pages per Extent. This means that the data is contigious.

Try REPLICATE.

Please give us some more info to work with!

Example; What SQL Server version, At what stage is the SQL Mail process slow etc....

How critical is it to update the aggregations on the other Tables ? Example; RealTime, every 1 hour etc...

NO!