access linked tables (again)

[anthony.k.farrant]

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
"description" 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

[Rich P]

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(sqlsrv2000) 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 ***