Asger Blond
ab-mi at post3.tele.dk
Thu Jan 21 13:39:41 CST 2010
That's right, you can't create an index on a linked table or view using design view. You can however create the indexes in SQL Server Management Studio - and then you will see in design view of the table or view in Access. Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Kaup, Chester Sendt: 21. januar 2010 14:27 Til: Access Developers discussion and problem solving Emne: Re: [AccessD] SQL Server Link The SGL Server view has two indexes on one of the underlying tables. When I link to the table through access it of course allows for only one index. If I open the table in design view it, add an index and close the table access responds "Microsoft Office Access can't save property changes for linked tables". -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond Sent: Wednesday, January 20, 2010 6:44 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] SQL Server Link You can make indexes on a SQL Server view provided that the view meets some conditions (among others the view must be made with schemabinding and no outer joins are allowed). The first index created must always be a unique clustered index. Then you can build additional non clustered indexes on the view. You say you are able to create one index your view. Then your view seems to meet the conditions, and I don't understand why you shouldn't be able to create additional indexes. What error do you get? From where do you try to create this index (a query in SQL Server Management Studio, an Access query, a procedure in an Access module)? Asger -----Oprindelig meddelelse----- Fra: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] På vegne af Kaup, Chester Sendt: 20. januar 2010 20:34 Til: Access Developers discussion and problem solving Emne: [AccessD] SQL Server Link Is it possible to create two separate indexes to a SQL server view. One is no problem but two has me stumped. Thanks. Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com