Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    15

    Unanswered: Append query between Access 2010 application and ASPX.NET Web application (MSSSQL)

    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

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Sure, most of my applications use Access as a front end to SQL Server tables. Simplest is if you can link to the SQL Server tables.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •