Post reply

Replication with MS Access 2007 and Sql Server

  • August 2, 2011 at 2:13 pm

    #254801

    I have a client who currently uses MS Access 2007. His employees us a MS Access application on PDA’s to collect data and then once the data is collected he needs an automated way to enter/update the data in the master database. I know MS Access no longer supports replication and I suggested the possibility of migrating to Sql Server for his master database.

    Does anyone know if it’s possible to set up replication between MS Access and Sql Server?

    Can someone recommend a possible solution or point me in the right direction to get the information I need?

    Thanks

  • August 2, 2011 at 2:20 pm

    #1362625

    SSIS package might be the way.

    Never done this tho, no idea how easy / hard it can be.

  • August 2, 2011 at 2:38 pm

    #1362642

    Thanks,

    I thought about SSI, but I need information on the replication aspect and if it can be done.

  • August 2, 2011 at 2:42 pm

    #1362646

    I was thinking more about a import package that merges the data on SQL Server.

    Then maybe redownload everything to access if need be.

  • August 2, 2011 at 3:03 pm

    #1362667

    After doing some research I found out that Sql Server compact edition can be installed on a PDA. I also found out that Sql Server Express can only be a subscriber in replication.

    I'm trying to figure out what I should reccommende to my client.

  • August 2, 2011 at 3:06 pm

    #1362670

    Stepping out... out of my league here.

    Good luck with this.

    As a final not, a solution you feel competent in providing is always a good start...

  • August 2, 2011 at 3:24 pm

    #1362690

    E McNeill (8/2/2011)

    I have a client who currently uses MS Access 2007. His employees us a MS Access application on PDA’s to collect data and then once the data is collected he needs an automated way to enter/update the data in the master database. I know MS Access no longer supports replication and I suggested the possibility of migrating to Sql Server for his master database.

    Does anyone know if it’s possible to set up replication between MS Access and Sql Server?

    Can someone recommend a possible solution or point me in the right direction to get the information I need?

    Thanks

    I'm not sure if the statement marked bold is true...

    As per this link ACCESS 2010 still support replication, as long as the mdb file format is used.

    Disclaimer: I never used ACCESS replication nor am I planning to do so. It's just a result of a google search... 😉


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • August 2, 2011 at 3:28 pm

    #1362698

    Nice catch lutz!!

  • August 2, 2011 at 3:28 pm

    #1362699

    You can Create a Queries on SQL and then run the SSIS Package or u can use Bulk insert as well 🙂

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply