Managing SQL database with MSDE and Access 2000

• lucg

  SSC Enthusiast

  Points: 103

  More actions

  October 3, 2001 at 2:53 pm

  #157819

  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?

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 3, 2001 at 3:14 pm

  #418645

  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

  Andy
  Connect with me on LinkedIn

• lucg

  SSC Enthusiast

  Points: 103

  More actions

  October 3, 2001 at 3:29 pm

  #418646

  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

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 3, 2001 at 8:30 pm

  #418652

  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

  Andy
  Connect with me on LinkedIn