Mike & Doris Manning
mikedorism at adelphia.net
Fri Jun 11 10:53:24 CDT 2004
In SQL Server, you use ALTER instead of CREATE to change an existing object. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, June 11, 2004 11:41 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] SAVE VIEW The SAVE VIEW keyword causes some SQL statements to be stored as a view in SQL Server and other database engines. It does not work in Access. Is there a replacement for that syntax that does work in Access? CREATE VIEW Members AS SELECT * FROM MemberDetails John W. Colby www.ColbyConsulting.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com