Back end Files are slow to access from another server. SQL convert?

Posted on 2011-04-28
Last Modified: 2012-06-27
i have my back end files on another server. It takes a long time to access the files from one server to another.

 Would converting to SQL make the accessing faster? if so, what version would be a minimal recommendation?
Question by:repco
    LVL 56

    Accepted Solution

     Without a lot more detail, that's hard to say, but the answer is usually yes.

      At it's simplest, you move the data to SQL server and then use ODBC linked tables.  With that, your app may need minor tweaking.

      To really harness the power of SQL Server though, you would need to move onto using pass-through queries, triggers, and stored procedures.

      You might even want to go as far as re-writing parts of the UI, as writing for a client/server setup is different that what you'd normally do with JET/ACE (i.e. simply bind a form to a table).

      Depending on the size of your DB, you can probably try out using ODBC linked tables with SQL Express Edition and see what kind of results you get.

      Also, just because your "slow", don't assume there is no room for improvement with your current setup.  Have your checked your indexing?  That's critical for a JET/ACE based app.    Might want to give the DB Performance analyzer a go and see if it suggests anything.



    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now