I want to delete it because I was experimenting with adding a DTS package on a production server and using my local sever as a destination.  The package was added,...

Thanks to ThomasH as well.  Your suggestion is a simple change that cuts down network chatter.

Thanks kknudson.  I put the offending server in its own group and collapsed the group and no more network traffic.  I also upped the time between polling the servers to...

Can you confirm if the dates are stored correctly in the table or not.  That is when you SELECT BatchNum, FromDate FROM BillingSummary do the dates match properly?

If not I assume...

I assume Utility.Buildlistbox just gets the data from SQL Server and populates the listbox.  Is this method already written and you are trying to use it?

You missed:

INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Alberta')

Also

INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Newfoundland')

should be

INSERT Lookup_User_StateProvince(StateProvinceText) VALUES

I hadn't connected to this server since starting EM so I didn't even have a green arrow (just an empty circle)  yet EM sees fit to transmit periodic TCP/IP polls. ...

Trigger happen when you change a record (INSERTS or UPDATES) so if I Update a table I can take some kind of action.  If you are running SQL Server 2000...

Trigger happen when you change a record (INSERTS or UPDATES) so if I Update a table I can take some kind of action.  If you are running SQL Server 2000...

You need to decide how you intend to read/update the data.  If you are doing this is VB.net see a tool like LLBLGEN (http://www.sd.nl/software/)  If you are using VB 6...

Try http://www.sqlservercentral.com/scripts/contributions/153.asp for an automated triggering solution.  This could be the basis of what you need.

You may not have the latest service pack for Access.  See http://support.microsoft.com/default.aspx?scid=kb;EN-US;272384  Overflow errors are documented here.

Bonne Chance.

With respect to your first question.  It is very likely that repeated queries to the same table may be faster if you "do a single query first to return the record...

Try a slight modification of brendthess's suggestion:

Declare @mySQL nvarchar(500)

Declare @myParms nvarchar(100)

Declare @sz int, @CT int

SET @mySQL = N'SELECT  @sz = sum...

Server administration was blocking the port. Thanks