Can you link a SQL view with Access 2000? Thanks, Lynn.
B Brian Camire Nov 14, 2003 #2 Yes. To Access it appears as a linked table. If you want it to be updatable in Access, you need to create a pseudo index *in Access* on the linked table. See the help topic on the "CREATE INDEX" statement for details.
Yes. To Access it appears as a linked table. If you want it to be updatable in Access, you need to create a pseudo index *in Access* on the linked table. See the help topic on the "CREATE INDEX" statement for details.
