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

    Linking access database to tables in sql server is enough?

    Hello
    For linking access database to sql server, linking from access to tables in sql server is enough or we have to modify other objects like queries or forms.
    Because Before I had spilited my access database and it was working. Now I have linked that database to sql server, it will be hanged in some cases.


  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    You split database because you have some Access tables in addition to the SQLServer tables?

    As long as the links in the FE to the tables have the same names as the tables, queries and code should work.

    What do you mean by 'hanged'?
    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
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78
    before adding sql server tables i had splited my database , and it was working.
    now i have deleted linked tables in the FE of my access db and used links to sql server and also rename my tables in FE , for example i rename my table from "dbo.tbldocuments" to "tbldocuments", actally i cleared just "dbo." that have been added after linking to sql server.
    i do not know it some times hanged.

    Best regards.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Sorry, I don't know about the hanged issue. I have never used SQL Server.
    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.

  5. #5
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,067
    When linking to SQL Server I've gotten table names of dbo_ never dbo. was this a typo or is dbo. what your actually getting.

    I've never had an issue linking to sql server tables.

    The biggest thing to watch is make sure that the link is to the proper DB and not MASTER. I've had several users here create an access DB link to SQL Server and forget to change the default database to the proper one and can't figure out why their tables aren't showing up.

  6. #6
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Also, the tables in SQL Server NEED to have primary keys. And yes, sometimes things need to be handled somewhat differently. So I think you just need to work through the issues as they come up. Eventually you'll be there.

  7. #7
    masoud_sedighy is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Dec 2011
    Posts
    78
    thanks

    I had forgot to make link for one of tables. so i link that and now it works.

    Best regards.

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

Similar Threads

  1. Replies: 3
    Last Post: 09-07-2011, 03:17 PM
  2. Replies: 1
    Last Post: 07-16-2011, 01:40 PM
  3. Replies: 0
    Last Post: 03-04-2011, 10:28 AM
  4. Linking Database tables and forms
    By shaileen.shah in forum Access
    Replies: 1
    Last Post: 02-16-2011, 03:08 PM
  5. MS Access linking to MS SQL tables
    By OdeonKreel in forum Access
    Replies: 3
    Last Post: 01-27-2011, 11:05 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