Agreed. I was just addressing the mapped drive mis-information. Abdul should check permissions, although the error does not seem to indicate that problem.

I would say that almost 100% of the...

Mapped drives only work when a user is logged in to the system (server, workstation, whatever). DTS runs under the SQL Server Agent SERVICE, which does not use any logged...

I don't know anything about time stamps, but importing an identity field is easy. Map the identity field from the Access DB to the identity field in SQL Server, then...

I suspect you have a major permissions problem. When you run the sp in QA, you are running it using your permisisons, on your local workstation. When you run the...

In the first place, I have never really had any problems moving columns around, but I usually do it in the pliminary stages and there is not much data in...

There has been much discussion around dropping duplicate records, especally when they are not necessarly dupes. In my case, there is an Adjustment Date and Adjustment Time that for some...

If you are just concerned with firing off a .BAT file, then you don't even need to use DTS, just the job scheduler.

The only caution I have is be very...

Just remember that SQL only has a max record length of 8,000.

When you export to Access, there is a parameter for the maximum of allowable failed transfers. It's default is one row.

Usually, when I see this it is because of...

Lee's script is great as long as you do not have a row with nulls. I modified the query as follows to eliminate that problem:

DECLARE @sql        VARCHAR (8000)

       ...

I find it interesting how many users do not understand that scanning a document is not the same as a document file. I get lots of requests to 'Please scan...

Yes, I do, our church secretary, for one. She prints the Email, files it in the file cabinet, then deletes Email. The pastor has no clue anybody has sent him...

Interesting reading, thanks. You make some valid points.

The 'paperless office' has been thrown around for about 20 - 30 years. In my opinion, the MAJOR issue has nothing to do...

Got Access? If you do, it might be the easiest, quick and dirty way to develop a report.

I am using an Access Project app, and there is an ADODB Connection parameter called CommandTimeout, which works for extending the query time out. You might search for that.