This is a really simple example. Hope it helps.

DECLARE @datadetails TABLE

(

dataid int,

[name] char(1),

amount money

)

INSERT INTO @datadetails VALUES (1, 'X', 34500)

INSERT INTO @datadetails VALUES (2, 'X', 1600)

INSERT INTO @datadetails VALUES (3,...

What do you mean by datagrid contents ? I assume you are binding something to the datagrid in order to display it. Is it a datatable, array, custom...

You need to check the SQL Mail set up. i.e.

Right click the SQL Mail item under Support Services in Enterprise Manager. What is the Profile Name that is set up...

Syed,

It now sounds like the reason it works from your machine but fails with the Access Denied when scheduled and now with the MAPI error is as I said the...

Syed,

From the trace it seems you are successfully importing data until sometime after row 6000. I need more information on the error to help you find out what...

Also, another point, don't forget that when you run the DTS package manually it runs under YOUR security context i.e. the credentials under which you registered the sql server. ...

lol. Yes, I only put the create table and record stuff in to illustrate the point. As for scheduling, just put the script in a SQL Agent scheduled job...

This is a little script that creates a table, inserts some rows, then does the checking, emailing and updating you described. Obviously you will need to replace the table...

Oscar,

Depending on what application/installation package you're installing it with etc. it isn't too difficult.  This link for deploying Access based apps with MSDE might be useful.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/msdedeploy.asp

Dan

You should be okay if you change your code to

If txtDOB.Text.Trim().Length = 0 Then

Session("DOB") = DBNull.Value

Else

Session("DOB") = txtDOB.Text