Results 1 to 3 of 3
  1. #1
    AcroJumper is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Aug 2017
    Posts
    1

    DSN: Difference Access 2010 vs. 2013

    Hello,

    My company is not very big, but we have a department that sees about 30 individuals using an Access db to manage workflow. The department head created the database through out the past few years and it has steadily gotten bigger over that time. All users utilize the front end only interface that calls on the back end database. This works fantastic for Access 2010, however all users must retain Office 2010 for this reason. Anytime in 2013 and/or 2016, when calling on tables from the form we receive the "Select Data Source" window. This is where I am stuck. What has changed with access from 2010 to 2013 to cause this?

    There is intention to migrate to a full SQL server in the future, but things take time. Currently we are stuck with trying to figure this out.

    If anyone has any direction to move forward, that would help.

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389
    Anytime in 2013 and/or 2016, when calling on tables from the form
    What does this mean? How do you "call on tables"?
    Could you post an image of the error message box?
    Can you see the tables in the Navigation pane?
    if so, can you open a table to view its contents?

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    All users utilize the front end only interface that calls on the back end database
    if this means they are all using the same front end file, this is likely to be the problem. Users should never share a front end but should have their own copy located on their machine. And if they have different versions, the reference libraries access uses are different which may explain the error.

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

Similar Threads

  1. Access 2010 or 2013?
    By Jennifer Murphy in forum Access
    Replies: 8
    Last Post: 12-09-2015, 12:50 AM
  2. Replies: 4
    Last Post: 11-20-2014, 01:05 PM
  3. Replies: 6
    Last Post: 08-13-2014, 10:32 PM
  4. Replies: 5
    Last Post: 09-11-2013, 03:42 PM
  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