Converting from access 2002 to access 97


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Converting from access 2002 to access 97

  1. #1
    Join Date
    Jan 2009
    Posts
    23

    Converting from access 2002 to access 97

    This may be a little crazy.

    I know very litle about databases but am very comfortable with vb6.



    Since VB6 is becoming passe the only books on vb6 and databases were written ten years ago and the code samples used access 97.

    There are several database programs with the vb6 code in these books that were written in access 97 that meets my needs. I don't want to become a database expert but I can slog through the code to make minor changes.

    I have access 2002 on my computer.

    Each time I try to open the databases in access 2002 that came with these vb6 program an error message appears telling me that this database cannot be opened by access 2002 and must be converted.

    When I try to use the new access 2002 database in the vb6 program an error message appears saying "unrecognized database format".

    This database applications are for a desktop and simple "enter the telephone number and get the customer data" with some none primary attached tables.+++++++++++++++++++++++++++++++++++++++++++++

    My mind says that the easiest way out of this is to install access 97 on my computer.

    QUESTIONS:
    1. Can a vb6 program written for access 97 be "easily" converted to use with access 2002 if I stuck with access 2002?
    2. Can I have a problem with both access programs on my computer?
    3. Can I disable access 2002 temporarily so only access 97 works?
    4. Can I add/delete fields in the access 97 database with access 97?
    5. Am I crazy to go back to access 97?

    Thank you very much for your help?

    Bill Miller

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    A much simpler solution is to install the latest Service Pack for Visual Studio: http://msdn.microsoft.com/en-us/vstudio/aa718360

    See this article for more information: http://support.microsoft.com/kb/238401
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Access 2002 iif function bug?
    By Farli in forum VB Classic
    Replies: 1
    Last Post: 07-02-2002, 08:00 PM
  2. YAG's public status report - March 7, 2002
    By Seth Grossman [MSFT] in forum vb.announcements
    Replies: 1
    Last Post: 03-13-2002, 08:32 PM
  3. VirtualQueryEx
    By MacDeath in forum VB Classic
    Replies: 2
    Last Post: 02-14-2001, 06:44 AM
  4. Data Access Pages to Emulate Website on CD
    By John Simmons in forum Enterprise
    Replies: 0
    Last Post: 02-09-2001, 01:42 PM
  5. converting Access databases to SQL
    By Veronica in forum Database
    Replies: 2
    Last Post: 05-17-2000, 09:16 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