RE: DROP VIEW problem

[Matthew Walker]

In Access you have to use drop table to delete a saved query - not drop
view.

-----Original Message-----
From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 25 February 2004 10:20 a.m.
To: CF-Talk
Subject: DROP VIEW problem

drop view vieInvoice;

Gives the following error:

Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in DROP TABLE
or
DROP INDEX.

Any idea why?  This works on my local box.  And I've checked with the IPS
and
I've got DROP privileges with MX Administrator.

Andy Ousterhout
O'My Goodness
www.omygoodness.com
910 Sherwood Drive, Unit 19
Lake Bluff, IL    60044

Phone 847.735.9890
Fax     847.735.9910
Yahoo IM:  andy_ousterhout

  _____

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---