Results 1 to 3 of 3
  1. #1
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92

    Where is the Field Properties of Source Database in SQL?

    Hi,

    I was trying to prevent a field on table to create duplicates. I was going to change the Indexed for it to "Yes (No Duplicates)" but the table is linked to the source. I learned that the source is located in a server. I went there and it's totally different look! I went to Tables and saw the table name and open it. I clicked the row for the field and was looking for "Indexed" to add the "Yes (No Duplicates)" but it is not showing the Field Properties. It only shows a Columns tab. Please help!

    Thanks,


    netchie

    Click image for larger version. 

Name:	ID No - Need to updated Indexed to No Duplicates.jpg 
Views:	18 
Size:	85.8 KB 
ID:	10358

  2. #2
    pkstormy's Avatar
    pkstormy is offline Access/SQL Server Expert
    Windows XP Access 2003
    Join Date
    Mar 2010
    Location
    Madison
    Posts
    682
    Modifying SQL Server tables should be done by a dba since this could impact any front-ends which have those tables linked (the linked tables typically need to be refreshed in all front-ends after modification). But if you're intent on modifying a table and creating a primary key (ie. Indexed - No duplicates) and you're prepared to refresh all the linked tables and fix any issues which happen from making a fairly major modification, you need to get into the design view of the table on SQL Server and after highlighting the field, you can click the button which looks like a "key" in the upper left in SQL Server Enterpise Manager (I think your snapshot cuts this button off on the top left side). You should also see all the properties of a field in a table right below the table design in SQL Server (similar to MSAccess). If you don't, then you may need to open SQL Server Enterprise Manager on the actual server where it resides or check your SQL Server permissions to make modifications to the table on SQL Server.

    You should first though run some queries to see how many duplicates are on that field (ie. "Find Duplicates" query wizard in MSAccess) since you won't be able to change it until the duplicates are removed or you'll get errors when trying to change it.

    Modifying SQL Server table designs should be done only by a SQL Server dba though since you may need to drop any relationships currently on that field and re-create them!

  3. #3
    netchie is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2010
    Posts
    92
    That sounds complicated

    Thanks for your input. I'll try to follow your steps.

    Thanks so much pkstormy!

    netchie

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 11-14-2012, 01:06 PM
  2. Replies: 2
    Last Post: 10-12-2012, 02:33 PM
  3. Replies: 5
    Last Post: 05-25-2012, 12:02 PM
  4. Replies: 2
    Last Post: 08-01-2010, 10:35 PM
  5. Setting Field Properties for Numbers
    By Tim Hardison in forum Access
    Replies: 1
    Last Post: 12-09-2009, 06:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums