There is nothing in the logs pertaining to loss of connections or related to the jobs in question.

Also checked the permissions and the SQL Service Agent service login does have...

Thanks.  In looking at the permissions on the server where the mdb file resides, the login for SQL Server Agent service didn't have rights to it.  Once we added rights...

The preference is to have security on it because the forms within the access file restrict the users from certain things and if there isn't any security on it they...

My headache is getting worse.  It was all running fine yesterday but now is failing.  I changed the drive mappings to UNC and that seems to have corrected it.  However,...

Yes, workgroups are very awkward and I try and avoid them at all costs.  Unfortunately, I kind of inherited this.

Anyway, I was able to solve the issue by just going...

That is what I thought but when I tried it, it tells me that the login is invalid because the workgroup file is missing.  I'm not sure how to indicate to...

Thanks Jeff!!  This really helped.  I was able to modify it and have it suit my needs.  Had some issues with getting the individual people's names (cn_contact table) to display...

I'll do a search on that but to give more clarrification on what I'm dealing with here is a simple example:

Company A (enid = 1,...

That works, thanks.

I tried that already.  All it does is round the number, which makes sense.  It still leaves four digits after the decimal though.  In this example it is 63568.3000

Thanks Joe.  Your latest suggestions occurred to me while stuck in a long meeting this afternoon.  I did not, however think of your final solution for handeling both variations at...

The problem I have now is that it is looking at the variable @FIELDNAME when setting the @NEWPHONE as just a string rather than a field in the database. 

I've...

- Not all squirrels live in trees.

- Who has more fun than people?

Some similar ones:

- He/she isn't the brightest bulb in the box.

- He/she isn't the shinniest tool in the tool...

Thanks.  Can you get me started on how to do it by writing the T-SQL against the schema?

Paulo,

You are correct, I'm looking for a query to help me do this to get it into relational tables.

As far as your other questions the number of rows in the...