Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    2

    Unhappy Unanswered: Migrating Access 97 tables to SQL Server

    --------------------------------------------------------------------------------

    I recently linked my access 97 tables to SQL Server using DTS. I am still using Access 97 as the front-end.

    Problem: When users access the tables in raw grid form and change things the whole app and tables lock or the app just timesout.

    Question: Is there a way to migrate from Access to SQL and have SQL administer the transactions? I heard that upgrading to Access 2000 resolves this issue. Any thoughts?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    If you're going to be running access 97 with sql server, you are definately better off using 97 as a front-end ONLY and keeping all data transactions on the SQL Server. And yes 2k is a great platform because you introduce ade's and a few nicities with regard to data connectivity.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •