You should be able to link the tables to the SQL data from the access database. From my past experiences with doing this it will work and you get...

I think the QOD's are great.  They get you thinking and researching the answers if you don't know them.  I feel this will make me a better administrator/programmer. 

The problem lies in...

I agree with Amit.  I got my answer from books-online (SQL2k sp3 Updated), and even tried it on a test table.  I received no errors from query analyser.

Thanks for that Jonathon.

The rowstamp field is a timestamp.

I did try using just the rowstamp in my testing, but soon discovered that some entries were inserted out of sequence rowstamp...

Create a task that backs up the main database and restores it to the test database

using scripts similar to the following:

BACKUP DATABASE [<DBName>] TO DISK = N'Replication.BAK' WITH...

Whether you go for 15k discs of 10k like has already been said depends on teh hard drive load. I would probably go for the 15k drives, as databases...

I had a lot of trouble with DTS packages, until i tried a different "Loading" method. Using the method you use, I was unable to get the package to...