I use MS Access 2000 and MSDE to manage my SQL database.
I am able to open the database in Access and view the tables but I cannot get the Design view in order to make changes to the field names, field length...
Sounds like the tables are linked. If you use Access with an mdb, tables in SQL/MSDE are linked and cannot be altered. If you're in project mode (.adp), then you can alter the tables if you have the appropriate permissions.
Thanks for the quick reply.
I am in project mode. So it would means that the problem would come from the permission settings on the SQL server?
Very likely. You'll have to be in the dbowner or ddladmin roles (or one of the system roles). Connect as SA if you can.
Viewing 4 posts - 1 through 3 (of 3 total)