Results 1 to 5 of 5
  1. #1
    sandeep23 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    May 2012
    Posts
    8

    Link MS ACCESS 2010 Database uto SQL SERVER 2008 R2

    Hi,



    I have a requirement. I have to link the MS Access 2010 web Database which i have created to sql server 2008 R2. My Requirement is, if i update the ms access database that should reflect the sql server database. If i insert a record in the ms access database table it should insert in the sql server database table.

    Please help me on this.. its urgent...!


    Thanks & Regards,
    Sandeep Kumar.

  2. #2
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159
    Quote Originally Posted by sandeep23 View Post
    Hi,

    I have a requirement. I have to link the MS Access 2010 web Database which i have created to sql server 2008 R2. My Requirement is, if i update the ms access database that should reflect the sql server database. If i insert a record in the ms access database table it should insert in the sql server database table.

    Please help me on this.. its urgent...!


    Thanks & Regards,
    Sandeep Kumar.
    I spent two or three days on this and it nearly drove me cracked!

    Your best weapon here is SSMA - SQL Server Migration Assistant!!

    Works like a charm! Let me know how you get on!

    http://www.microsoft.com/en-us/download/details.aspx?id=28763

  3. #3
    sandeep23 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    May 2012
    Posts
    8
    Thanks Richie..! I will download it and let u know if i get any issues...

  4. #4
    sandeep23 is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    May 2012
    Posts
    8
    Yes Richie, I have downloaded the SSMA for access and migrated the database. but when i insert new record in my ms access table. it is not reflecting in my sql server.

    My Requirement is, whenever i insert/delete/update a record in ms access table, it should automatically do the same thing in sql server.


    Thanks,
    sandeep.

  5. #5
    Richie27 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Feb 2012
    Location
    Ireland
    Posts
    159
    Well Really, when I did this I was using forms to insert/delete/update my access tables - so then when I migrated to sql server - sql server becomes your back end database so when you input into the forms it goes straight into sql server via a linked table - those tables with the wee globes with your table names - not the ones with ssma at the side of them.

    I would try what you are talking about just to see, but I won't be near my workstation until Monday so won't be able to test until then.

    If you ported in your db though, there really should be no problem. All I can suggest is that you experiment a little.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-17-2012, 05:41 AM
  2. Access 2010 through VPN and Win Server 2008
    By feguillen in forum Misc
    Replies: 1
    Last Post: 12-01-2011, 06:20 PM
  3. Replies: 1
    Last Post: 04-21-2011, 07:12 PM
  4. Can't connect Access 2010 to SQL Server 2008 R2
    By LAazsx in forum Import/Export Data
    Replies: 6
    Last Post: 12-10-2010, 08:44 PM
  5. .adp in access 2007 to SQl server 2008
    By NoellaG in forum Access
    Replies: 5
    Last Post: 09-07-2010, 09:18 PM

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