>I have used the Remote View Wizard to create a view named ORGANIZATION to a table ORGANIZATION in an Access97 MDB file.
>
>That worked. I can say USE ORGANIZATION and browse the table.
>
>Now I want to make this view Updateable. However, then I say MODIFY VIEW ORGANIZATION I get a syntax error without any more detail.
>
>What could be wrong here. It is the spaces in the field names of the original table?
>
>Is there some other way to make this view updateable without MODIFY VIEW?
>
>Thanks so much in advance.
>
>Hermann Strijewski, Toronto.
Do MODI DATA
Then, select the view from the database and right click, and select MODIFY from the shortcut menu. This will put you back in the view designer.
BOb
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement