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

    Post Unanswered: indexing linked views

    Hi,

    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

    Milan

  2. #2
    Join Date
    Feb 2004
    Posts
    3
    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
  •