Results 1 to 4 of 4

Thread: How convert Access 97 to 2000 with VB

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2002
    Posts
    1

    Unhappy How convert Access 97 to 2000 with VB

    Hello,

    is it possible to convert a access 97 format database to access 2000 with VB6? If so, please point me into the right direction.

    Thanks in advance

    embargo

  2. #2
    Member
    Join Date
    Jul 2001
    Location
    Grenada
    Posts
    38
    You dont

  3. #3
    Randalf the Red honeybee's Avatar
    Join Date
    Jun 2000
    Location
    off others' brains
    Posts
    4,345

    Well ...

    I think the new DAO 3.6 library allows you to use either an Access2K or Access97 database. And I, too, doubt if a conversion is possible through VB ...

    .
    I am not a complete idiot. Some parts are still missing.
    Check out the rtf-help tutorial
    General VB Faq Thread
    Change is the only constant thing. I have not changed my signature in a long while and now it has started to stink!
    Get more power for your floppy disks. ; View honeybee's Elite Club:
    Use meaningfull thread titles. And add "[Resolved]" in the thread title when you have got a satisfactory response.
    And if that response was mine, please think about giving me a rep. I like to collect them!

  4. #4
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Try

    Changing your connection string in VB to get the Access 2k (Jet.4 or Jet.3.5 can't remember which)

    Then use Access 2k and convert the dbs to new files. Then connect to these new files...


    Regards

    Vince

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width