Results 1 to 3 of 3
  1. #1
    Rzadziu is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    28

    Access 2013 query from mssql.

    Hi,

    I would like to create query which will search for a records in mssql 2008 database on server.



    How i should do this??

    BR Marcin

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Have you set links to the SQL tables?

    Build queries the same way you would with Access tables.
    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
    Rzadziu is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    28
    Yes i have link tables, unfortunately after restart database i have to put password and login again.
    Im using also excel where is very easy to create query to mssql, and i was thinking if it is possible to do this a same in access.

    Maybe someone is able to help me with thiss disappearing password problem??

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

Similar Threads

  1. Outlook 2013 + Access 2013 + HTML
    By Yann63 in forum Programming
    Replies: 2
    Last Post: 11-26-2013, 02:39 PM
  2. SQL Query challenge in Microsoft Access 2013
    By Bingfoot in forum Queries
    Replies: 5
    Last Post: 10-07-2013, 07:58 AM
  3. Replies: 12
    Last Post: 07-25-2013, 12:49 PM
  4. Access 2013 Web App with Sharepoint 2013
    By miguel.escobar in forum Access
    Replies: 7
    Last Post: 06-17-2013, 09:03 AM
  5. Populating identity field of an over-ODBC linked MSSQL table
    By Passiday in forum Import/Export Data
    Replies: 0
    Last Post: 11-16-2011, 11:49 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