Append query between Access 2010 application and ASPX.NET Web application (MSSSQL) (1 Viewer)

adi2011

Registered User.
Local time
Today, 13:23
Joined
May 1, 2011
Messages
60
Hi,


I plan to create some kind of Hybrid application, and I have a plan, but I would like to consult with someone who has more experience than me so I could avoid possible major mistakes.


I plan to create ASP.NET Web application (MSSSQL) which will end-users use for Ordering products.

I also have Microsoft Access 2010 Desktop DB which will have Append or Pass-through query which will update data in two tables on my Web application.

Is it possible to make solution like this, appending data from Access Jet DB to MSSQL? Should I also upggrade my Access 2010 Desktop DB to MSSQL?


Also, I have one more question. If I would like to do the opposite, and to read data from Web App, in Access 2010 Desktop DB, that would be possible to do I assume by creating linked-table?


Any help is appreciated and many thanks in advance!

Adi
 

adi2011

Registered User.
Local time
Today, 13:23
Joined
May 1, 2011
Messages
60
Sorry for that.

BR,
Adi
 

Users who are viewing this thread

Top Bottom