Results 1 to 3 of 3
  1. #1
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19

    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
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    15,682
    cross posted http://www.access-programmers.co.uk/...d.php?t=284949

    When you cross post --put same or similar request on multiple forums - please advise users that you have done so.
    Just add a link to the related post.

    Here's why.

  3. #3
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19
    Quote Originally Posted by orange View Post
    cross posted http://www.access-programmers.co.uk/...d.php?t=284949

    When you cross post --put same or similar request on multiple forums - please advise users that you have done so.
    Just add a link to the related post.

    Here's why.

    Ok, no problem, thanks.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 08-27-2015, 06:05 AM
  2. Replies: 4
    Last Post: 01-05-2014, 02:09 PM
  3. Access 2010 Application on Mac and PC?
    By nick.h in forum Access
    Replies: 3
    Last Post: 01-06-2012, 07:54 PM
  4. Replies: 0
    Last Post: 08-26-2008, 09:22 AM
  5. Access application to Web based application
    By admaldo in forum Access
    Replies: 0
    Last Post: 06-12-2008, 06:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums