Indeed, and you can even use the SQL DML statement CREATE VIEW against it (just note that if you try to use it in a CFQUERY, you might have that rejected not because of a problem with Access but instead a problem with the definition of the datasource. See the "CF Settings" button for the datasource in the CF Admin. You'll notice a choice called "Restrict SQL Operations to".
You can choose among the options to only allow either SELECT, INSERT, UPDATE, DELETE, or STORED PROCEDURES. Some people mistakenly choose all 5 intending to allow "everything" when instead that will specifically PREVENT anything BUT the option(s) selected, so if you try to use a CREATE statement (or a DROP or ALTER statement, etc.) and ANY of the options are checked, it will be rejected in the CFQUERY. /charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gustavo Jabbaz Sent: Monday, February 04, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] stumped on SQL Access does have views. G ----- Original Message ----- From: "carina cojeen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 9:01 PM Subject: Re: [CFTALKTor] stumped on SQL > thanks gustavo... i lost this email i was gonna send in reply to yours.. > > i don't think access has views though? but maybe now i understand a bit > better what views are for? > > thanks all again for your help. > > crc > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: carina cojeen <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Gustavo Jabbaz" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "charlie arehart" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
