Since you stated that SQL Server is running as NT Service\MSSQLSERVER I'm curious as to why are you asking for people to look at your attachment?

You already answered the question...

What happens if you set the SQL Server Agent Service to run as a Domain Account?

As a test change the SQL Server Service to run using your WIndows Domain Account.

ok, your running...

I thinks that I need a package that runs as a step in a job and if it finds the record in the table it executes the second step which...

I don't use SQL Server Express but you should have the COnfiguration Manager where you can check the Account that is used for the SQL Server, SQL Server Agent, etc.

You...

It has been a while since your last post.

So how is your project going?

BTW, the form that you use to enter the data should have the recordset properties set to the WOrk Order Table. Good Luck.:-)

mrwillcostello (9/5/2012)

---

Ok Everyone thank you for your help. Maybe there is an easier way to do what I want to do. First let me explain what this is all about.

I...

I have not bounced the Server.

I hope a lot going on and that instance is only used for...

I would not try and add to 5 different tables from one form.

The easiest way to do this would be to do the following:

You could have a command button...

Yes, I'm using the configuration Manager to change the Services.

I recall you mentioning in a...

Oh, well thanks.:-)

Yes faster especially over a slow network connection.

Bad code.:w00t:

Thanks Jo.

The problem seemed to be as a result of a server_id with a value of one as opposed to zero in the sys.servers Table.

There may have been some Null Values...