Managing SQL database with MSDE and Access 2000

  • 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?

  • 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

  • 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

  • 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 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply