[AccessD] SAVE VIEW

Access version?
The syntax you write here will create an Access query in AXP if you have
ANSI-92 compatibility turned ON. (Don't remember if 2000 did this, maybe
if patched/updated?)


Steve


-----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