File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

Dropping views in MS access

Piyush Tripathi
Greenhorn

Joined: Jan 28, 2009
Posts: 16
Hi,

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.

Regards
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2476
    
    7

According to MSDN, the 2007 version knows the drop view syntax.
http://msdn.microsoft.com/en-us/library/bb177897(v=office.12).aspxThere 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
Greenhorn

Joined: Jan 28, 2009
Posts: 16
Hi,

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

Regards,
Piyush
 
I agree. Here's the link: http://aspose.com/file-tools
 
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