October 3, 2001 at 2:53 pm
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...
Any idea?
October 3, 2001 at 3:14 pm
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.
Andy
October 3, 2001 at 3:29 pm
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?
Luc
October 3, 2001 at 8:30 pm
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.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply