access linked tables (again)

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • anthony.k.farrant@gmail.com
    #1

    access linked tables (again)

    Hello everybody,

    I am new to Access. I have to rewrite an app built with Access upon SQL
    Server.
    Access links to SQL Server with linked tables. Now i'd like to change
    the connection
    properties for the tables. I open up design view and the properties and
    I change the
    description. But my changes never stay. I know the field name is
    "descriptio n" so
    this is probable not the place to change this stuff. But where the hell
    do I do it?
    Is it possible or are the props READ ONLY?

    Thanks to all,

    Ant

    Tags: None
    • Rich P
      #2
      Re: access linked tables (again)

      If you are not using an Access ADP file (Access Data Project) then you
      have to make the changes to the sql server tables through the Sql Server
      Enterprise Manager(sqlsrv2 000) or the Management Console (sqlsvr2005).
      You can't make design changes to sqlserver tables that are linked to
      Access through ODBC.

      One other method of making desing changes to sqlserver tables from
      Access would be using ADO and writing some tsql statements like Alter
      Table tblx Add Description varchar(255). This would work provided you
      have the proper permissions on the server.

      Rich

      *** Sent via Developersdex http://www.developersdex.com ***

        Comment

        Previous template Next
        Working...