File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Dropping views in MS access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Dropping views in MS access" Watch "Dropping views in MS access" New topic

Dropping views in MS access

Piyush Tripathi

Joined: Jan 28, 2009
Posts: 16

I am trying to drop a view dynamically from MS access Database but the below syntax is giving incorrect syntax error.

I am using Drop view <view Name>.
Can anybody suggest what is the way to delete a view.

Jan Cumps

Joined: Dec 20, 2006
Posts: 2476

According to MSDN, the 2007 version knows the drop view syntax. are other people who reported the same issue, and solved it by using "DROP TABLE <viewname>"

We can help you better if you give us the exact error message.

edit jc: hyperlink fixed

OCUP UML fundamental and ITIL foundation
youtube channel
Piyush Tripathi

Joined: Jan 28, 2009
Posts: 16

The exact error message is "Syntax error in Drop Table or Drop Index"

I agree. Here's the link:
subject: Dropping views in MS access
Similar Threads
What is the syntax for a "drop down menu"?
I need help with "primary and foreign key" in my data migration code.... Please help.
JDBC & SQL Error List Help
code working in Appletviewer but not browser
[ODBC driver for Oracle][Oracle]ORA-00907 Error