what about open Enterprise manager .. and right click on your Database , choose All Tasks >> Backup database

Note that Linked Server is like you have only shortcut to your Access database ..

 and when you want to get data from it, you have to write code to pull data from...

where can I "trunc. log on chkpt" ?

 I get also this error

error 9002 : the log file for database 'MyyDB' is Full , back up the transaction log for the database

So the problem was the Log was...

try to also Check Argent Database for errors

by the way install SP3a .. it solved many Replication problems

by the way it is not recomended that you use serializable isolation level because it hangs all your other recourses .. because all operation is done in serial (not parallel...

by the way, I know that Windows 2003 has MDAC 2.8 installed, but try to install MDAC 2.7 SP1 on all clients and server machines

Also .. do you install SQL Server Tyoical Or...

by the way, what "a" is stand for in SP3a ?

use DTS (Data Transormation service) to transfer Tables Data and structure, to do this:

1- open Enterprise manager

2- right click on your Database and choose "All Tasks" >> "Export...

I still think there is some bugs between Windows 2003 and SQL Server 2000

try to install all windows updates ..

here is the solution of the Hang Problem between Access and SQL server 2000 or 7

When you want a report which based on...

This is a reply of Jeremy (Member of SQL Magazine Forum) whuch works best with me when I want to shrink a DB (I suugest you to Make Log Backup first):

SQL...

by the way, here is some links that may help u to understand OWC more

http://download.microsoft.com/download/c/2/8/c28831e9-684e-4aab-9af3-f061bf68ad70/WebCmpnt.doc

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B319793

http://support.microsoft.com/default.aspx?scid=kb;EN-US;235542

if you want more resources, I can send u 2 extra file on...

by the way I install SP3a and when i run

select @@version

(in Query Analyzer) I get this output : Microsoft SQL Server  2000 - 8.00.760 (Intel X86)   Dec 17 2002...