Don't forget, Abdul said it was working then stopped.  He never said he was using mapped drives.  UNC is the correct way to connect but if the scheduled job was...

We had a similar problem with a DTS package that could be run manually but was not running when scheduled.  Problem turned out to be a space issue on the...

Sorry,  things got busy around here.  By threshold limit I mean that we are now starting to see performance and speed issues, problems with memory resources on the server, queries...

I support an application that is a FE mdb linked to SQL Server through ODBC and currently we have anywhere from 150 to 200 concurrent users.  We are starting to...

Actually you can use a UNC name to link a FE access mdb to a BE access mdb.  I do this a lot.  Is the FE mdb file installed on each...

Access will not allow you to enter a invalid dates in a datetime datatype field so if your Access field is a datetime field you will not have any invalid...

You might also try this:

Select Left(Address,Len(Address) - CharIndex(' ',Reverse(Address)))

If you want to convert it to a mm/dd/yyyy format then use:

Convert(char(10),dteShipped,101)

This will take the datetime field dteShipped and convert it to a char(10) field in style format 101 which...

Another way to do it is:

Convert(char(8),dteShipped,1)

This will convert the date to a mm/dd/yy format.