Don't know if this is relevant but I had major problems with a SQL database connected to access after the SQL server database grew to be very substantial in size.

What...

What would be the best way picking up the name of the client computer that fired the trigger?

Chris

That will work nicely!

Thank you

The e-mail message is not going to work. I want an immediate message through windows messaging.

I figured it out you had to replace the "data" portion of the report. The 'connection' it sets up by default has none of the required information.

Create a query that returns the distinct records from ARmast. Then use that query in the above query. That should work for you.

I think if you created a linked server in SQL server (I have just learned that this is possible but I havn't done it) - pointing back to your access database. Then create a...

What is a consolidated date? I tried using a specific date/time in the were clause. Example where fdtForecastAsOfDate = '4/10/2002 9:00:40 PM' but this did not seem to work.

I will...