Results 1 to 3 of 3
  1. #1
    chiragrawal is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2013
    Posts
    3

    Access Database Project(.ADP) Migration to Access 2013 from Access 2007


    Hi All,


    I have a Access Database Project (.ADP) project in MS access 2007. We need to migrate the entire tool to MS Access 2013. But the (.ADP) format is not at all supported by Access 2013. So, our approach is to first Import everything in MS access 2007 ACCDB format, and then use this format in Access 2013.
    The approach worked perfectly fine for Tables, Macros , Modules & Forms but fail for Querie. The database connects with SQL server database as its back end. And these queries almost runs all the show. So is there any way out to get those queries in ACCDB format.

    Looking forward for a perfect solution, as i expect the Experts in this forum would definitely have the answer.

    Thanks a lot in advance.

    Best Regards,
    Chirag Rawal

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Bing: access 2007 import adp queries
    Is this relevant:
    http://answers.microsoft.com/en-us/o...1-2c70cfd7e811
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    chiragrawal is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2013
    Posts
    3

    Thanks for the effort, but this isnt useful!

    Thanks a lot man, for the effort but this isn't relevant. Sorry to say that.
    What i am looking for is a way to get queries into ACCDB.
    I have made few development, heard that it can be done using a pass through query via VBA.
    Will explore it now on.

    Quote Originally Posted by June7 View Post
    Bing: access 2007 import adp queries
    Is this relevant:
    http://answers.microsoft.com/en-us/o...1-2c70cfd7e811

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

Similar Threads

  1. Access (2013) database in Sharepoint (2007)
    By Yellowboat in forum SharePoint
    Replies: 1
    Last Post: 01-28-2014, 04:58 PM
  2. Replies: 1
    Last Post: 10-14-2013, 12:59 PM
  3. Replies: 12
    Last Post: 07-25-2013, 12:49 PM
  4. Replies: 2
    Last Post: 06-19-2013, 09:08 AM
  5. Migration from Access 2003 database to Access 2007 database.
    By cyclus2 in forum Import/Export Data
    Replies: 1
    Last Post: 09-10-2010, 11:43 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