Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Post Unanswered: indexing linked views


    can somebody help me with problem how to create index on linked table (view). I have database on mssql7 and views from sql database linked in msaccess. I need to update data in these linked views but until I will have no unique index, access not alow me to update anything in the views. When I link the view manualy, it ask me to select primary field and then it works, but I need to perform linking of views by code. I tried CreateIndex in TableDef but it tell me that it is not allowed on linked table. Any suggestions, Thanx


  2. #2
    Join Date
    Feb 2004
    Did you ever get an answer? I have the same problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts