How to delete table from Access 97 database table


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to delete table from Access 97 database table

Hybrid View

  1. #1
    Join Date
    Oct 2005
    Posts
    95

    How to delete table from Access 97 database table

    Hi

    I like to know how to drop or delete table from Access 97 database . I am trying to drop two table from one of my Access 97 database but it is not working . Also I would like to know how to convert a Access 97 database to Access 2003 database . Every time I try to convert it I get a error saying that my Access 97 database is corrupted . Please help

    Thanks

  2. #2
    Join Date
    Dec 2003
    Posts
    2,750
    You should just be able to do a DROP TABLE command.

    Have you tried compacting the the database in Access 97 before converting to 2003?
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Similar Threads

  1. Database Design Help needed
    By Brian Pittman in forum Database
    Replies: 2
    Last Post: 04-29-2007, 09:23 AM
  2. Replies: 7
    Last Post: 07-01-2002, 02:54 PM
  3. logic to copy ODBC table to Access database
    By Vince in forum VB Classic
    Replies: 2
    Last Post: 05-13-2002, 05:24 AM
  4. Access 97 to 2000 Conversion Error
    By Michelle in forum VB Classic
    Replies: 8
    Last Post: 04-19-2002, 06:01 PM
  5. How to analyze corrupted Access databases
    By Raffaele in forum VB Classic
    Replies: 15
    Last Post: 06-27-2001, 10:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center