Primary key and table name

[JCnonIT]

I am accessing a SQL database using Access but its not letting me view the table in design so I can set a primary or letting me change the table names.

I am able to do this from my home PC but not at work. Is there something in options or ODBC settings on the work the PC that I need to change.

Any Help will be greatly apprectiated.

JC

 

[llkhoutx]

Assuming you mean SQL Server, I think that changes changes you want have to be done from the SQL Server side, not in Access. Think about it.

 

[JCnonIT]

SQL server

Assuming you mean SQL Server, I think that changes changes you want have to be done from the SQL Server side, not in Access. Think about it.

It is letting me do it in MS Access at one PC.

JC

 

[RV]

JC,

it could be that you're restricted to manipulate your data structure.
You better liaise with your IT department.

As for llkhoutx's remark, you should not manipulate your data structure other then directly from within SQL Server (or whatever database is used).

RV