Creating an Updatable Query on a View

[willgreene99]

Hello,
I have a SQL Server 2000 database. I have a table with more indexes than Access can handle when trying to link the table. I created a view of the table in order to link it and to perform queries against it. I would like to be able to run update-able queries from Access, but I haven't found that info yet.
Any help would be appreciated.

Will

 

[PHV]

Did access assign a PK to the linked table ?
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

You need to either select fields that create a primary key when linking to the view or run a data definition query to add a virtual primary key.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]