Results 1 to 8 of 8
  1. #1
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78

    After splitting Ms Access to sql server for execution queries which engine is used

    I would like to know After splitting Ms Access to sql server for execution queries inside access , engine of ms access used or engine of ms sql server?

    After splitting to sql server (back-end) How many users can use ms access front-end ? Is there still limited of number of users when we use ms access (front-end) and ms access (back-end)?



    Can we transfer queries inside ms access also to ms sql server?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The short answer is, "it depends". Generally speaking, Access (JET/ACE) will try to pass the query back to SQL Server to execute. It won't be able to if there are Access-specific functions, a custom VBA function, etc within the query. In other words, things that SQL Server wouldn't understand.

    SQL Server is much more robust, and can handle a large number of concurrent users. More info:

    https://docs.microsoft.com/en-us/sql...uration-option

    You can convert Access queries to SQL Server views, stored procedures, functions, CTE's, etc. There are a lot of tools available in SQL Server.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Bing: Access database how many users

    Review: http://blog.fmsinc.com/microsoft-acc...an-it-support/
    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.

  4. #4
    Join Date
    Apr 2017
    Posts
    1,673
    The one (and simplest) way is write views in SQL database (they are like access saved queries), and connect them into your front end (like you connect tables).

  5. #5
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78
    For connecting queries in ms access to views in sql server how i have to do after making related views in sql server?

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    You can link to the view just as you link to a table, and use an Access query to query it. You can also use a pass-through query to query it directly on the server.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Maybe I am reading this wrong
    Quote Originally Posted by masoud_sedighy View Post
    <snip>
    After splitting to sql server (back-end) How many users can use ms access front-end ? Is there still limited of number of users when we use ms access (front-end) and ms access (back-end)?
    <snip>
    My answer would be 1.
    Multiple users in the same FE will corrupt your data at some point!
    Multiple users in the same FE is a known cause of corruption.

    EACH user should have a copy of the FE on their own computer. Thus 1 user.
    But many users/FEs can be connected/linked to the SQL Server BE (or to an Access BE).

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I read it as "how many front end users can there be when the back end is SQL Server instead of Access", but I may have misread it. I'd certainly agree that each user should have their own copy of the front end.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. access database engine does not recognize
    By slimjen in forum Forms
    Replies: 8
    Last Post: 05-30-2014, 11:53 AM
  2. Replies: 6
    Last Post: 11-12-2012, 11:01 PM
  3. Replies: 6
    Last Post: 05-14-2012, 08:32 PM
  4. Union Queries when Splitting Database
    By jaypoppin in forum Queries
    Replies: 3
    Last Post: 03-04-2011, 06:06 PM
  5. Splitting DB; Keeping the Forms, Queries, Reports in BE
    By evander in forum Database Design
    Replies: 2
    Last Post: 07-07-2010, 04:59 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