New to SQL Server

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Patrick
    #1

    New to SQL Server

    Hello
    I would like to convert my Access Backe End to SQL Server, but the
    first thing I notice when connecting to an ONC Table is that the name
    is preceded by dbo_ therefore it will not be recognised by the Access
    Front End.

    Does this mean that all the references to table in queries and in code
    will have to be changed?

    Or am I missing something?

    Patrick
    Tags: None
    • Simon Hayes
      #2
      Re: New to SQL Server

      Patrick <info@businessf ormat.co.uk> wrote in message news:<6bha10ta4 3ncjr67i2vsqj0h u4ffhvbe9o@4ax. com>...[color=blue]
      > Hello
      > I would like to convert my Access Backe End to SQL Server, but the
      > first thing I notice when connecting to an ONC Table is that the name
      > is preceded by dbo_ therefore it will not be recognised by the Access
      > Front End.
      >
      > Does this mean that all the references to table in queries and in code
      > will have to be changed?
      >
      > Or am I missing something?
      >
      > Patrick[/color]

      All objects in SQL Server have an owner, in this case dbo which is the
      database owner. So I guess Access is using that naming convention to
      be able to distinguish between a table owned by dbo, and another one
      with the same name owned by a different user:

      dbo.SomeTable -> dbo_SomeTable
      simon.SomeTable -> simon_SomeTable

      I have no idea how you can handle this in Access with minimum changes
      - you may get a better answer by posting this in an Access newsgroup.

      Simon

        Comment

        • Michael Beck
          #3
          Re: New to SQL Server

          After I create the link, I rename it and remove the 'dbo_'. This work
          fine. However if you change the structure in SQL Server, you must delete
          the link and recreate it rather than use refresh link.

          Mike
          Patrick wrote:
          [color=blue]
          > Hello
          > I would like to convert my Access Backe End to SQL Server, but the
          > first thing I notice when connecting to an ONC Table is that the name
          > is preceded by dbo_ therefore it will not be recognised by the Access
          > Front End.
          >
          > Does this mean that all the references to table in queries and in code
          > will have to be changed?
          >
          > Or am I missing something?
          >
          > Patrick[/color]

            Comment

            Previous template Next
            Working...