just a hunch, the SQL Server should have rights to write to the file server where the Access file is stored. 

Do you get the same errors when a 2nd user opens Access and tries execute these tasks?

Thanks for the tip.  We rebooted the surver and the problem is now fixed.

Have you checked to see if every field in the report comes from the query which works ok?

I have seen pages return a different number format than what Query Analyzer will display.  I have been able to solve it by:

1.  Deleting the field on the page

2.  Cast the field...

Are you using an adp for Access?  What is the source of the data, a table, view or SP?   

I made the assumption that when you coverted the mdb to an adp that you did both databases.  Now that I understand the issue here is an approach.  Move the table(s)...

You can create a view on SQL Server to view tables from other databases.  You will be able to read and write to that view from the adp. 

Paul,

I have the same problem when I use a SQL Stored procedure as the object of the form or subform.  I have switched to a SQL Server view and the...

DTS is much simplier and more reliable than any tools in Access.

You may try creating a job without a schedule that executes the DTS.  Then from VB execute the job.

Another option is to convert your view to a store procedure.  You will be able to view the store procedure from an Access project or even Excel.

I have tried similiar solutions and found dts more reliable.

Access comes with a sample file called NorthwindCS.adp.   To use open the file then click on file, connection and then point to the location of the Northwind database on your...

When you schedule a DTS from the DTS it will create a job.  Does that job fail also?