Why popup message box only can be closed one time?

Question

Hi All,

I need some help at following scenario

Had an Ajax message popup box after clincking "Submit" button (page A) to tell the user that Thank you for submitting, on which have an "OK" button

the problem is:

1) if it is the first time have the popup, click "OK" the msg box will be closed, and back to previous page (page A)

2) On page A, click "Submit" button again, popup box would be displayed again; but click "OK", the msg box will not disappear.

Does anyone give me some suggestion? Thank you in advance.

Ellen

Answer 1

Yes, as per Nitin, you can use SSIS which load the MS Access data to SqlServer.

 

If you are not comfortable with SSIS then create windows service which will run daily basis and do the job. Means everyday it will create an .sql file and then execute the sql file in server.

Answer 2

May be you should look into SQL Server Integration Services (SSIS).

Answer 3

Hi,<br><br> Please go through below thread-<br> http://stackoverflow.com/questions/10577237/ms-access-to-sql-sever-in-c-net