Results 1 to 8 of 8
  1. #1
    Esmatullaharifi is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    40

    Question Query not working after migrating to SQL Server 2014


    I am using query that work fine but after that i migrate and linked the table to SQL Server 2014 the queries are not working.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Is it an UPDATE query or what?

  3. #3
    Esmatullaharifi is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    40
    not just select query.

  4. #4
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    did you select an index when you linked to SQL Server?

  5. #5
    Esmatullaharifi is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    40
    what do you mean by index. I don't know.

  6. #6
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    when you link to sql server through odbc you are prompted to identify the index (tho' I don't know about SS14). If you don't provide this, the query may not work

  7. #7
    Esmatullaharifi is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Nov 2014
    Posts
    40
    but SSMA don't asked me about any index. Also some of queries work and some of them are not.

  8. #8
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Sorry, I'm out of ideas

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

Similar Threads

  1. Replies: 8
    Last Post: 11-05-2015, 06:06 AM
  2. problem with VBA after migrating to SQL 2014
    By Esmatullaharifi in forum Programming
    Replies: 1
    Last Post: 04-03-2015, 07:01 AM
  3. Replies: 3
    Last Post: 01-27-2014, 02:45 PM
  4. Replies: 2
    Last Post: 03-24-2012, 01:29 AM
  5. Replies: 0
    Last Post: 12-01-2011, 10:23 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