Results 1 to 4 of 4
  1. #1
    Sck is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2010
    Posts
    82

    Develop in Access 2013 run in Access 2010

    I am running Access 2013 (32 bit) on my machine and have been asked to develop a database for someone who is running Access 2010. What issues am I going to run into and is there anything I can do to mitigate them. I code in VBA but do not use any really advanced features (basic form operations, recordsets, and sql statements)



    Thanks in advance

  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,931
    If you don't use any Access 2013 features (I think 2013 took away more than it added), should be able to open the db in Access 2010. Although might be some issue with setting VBA library references.
    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
    Sck is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Jul 2010
    Posts
    82
    Just did a check and there is a reference issue. 2013 references office15 dlls I can go in on the Office 2010 machine and manually correct the references and the db runs fine.

    Is there a way to add the office 2010 ( office14.dll(s)) to office 2013 so I can set the reference on my machine or programmatically have the db correct missing references?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    I don't know if the older dlls can be added to 2013, I have doubt.

    It is possible to programmatically set a library reference and maybe handle MISSING reference error. Review http://allenbrowne.com/ser-38.html
    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.

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

Similar Threads

  1. Modify Access 2010 using Access 2013
    By martinmcnally in forum Access
    Replies: 2
    Last Post: 07-27-2014, 07:51 AM
  2. Replies: 1
    Last Post: 12-26-2013, 09:41 AM
  3. Replies: 1
    Last Post: 10-14-2013, 12:59 PM
  4. Replies: 1
    Last Post: 10-14-2013, 03:54 AM
  5. Replies: 3
    Last Post: 06-19-2013, 04:45 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