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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy