dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 10 of 10

Thread: I ask library open file access 2000

  1. #1
    Join Date
    Mar 2008
    Posts
    111

    I ask library open file access 2000

    i writing a programe, if i open file access 97 is very good, if i open file access 2000, It's warning "Unrecognized database format C:\data2000.mdb. -2466476642359". i want to ask library open file access 2000, i have had references: Microsoft DAO 3.51 Object Library and Microsoft ActiveX Data Objects 2.1 Library (or 2.5), but it still warning on, can you help me ?

  2. #2
    Join Date
    Mar 2009
    Location
    Italy - Breganze (VI)
    Posts
    120
    This because you use DAO 3.51 a very very obsolete.

    You must use ADO 2.8, instead of DAO, which allow you to open any database type and format like:
    Access (from '97 to 2007+), Oracle, SQL Server (to 2000 to 2008+), MySQL, Firebird, Postgres, e so on...

    Useful links:

    ADO Tutorial (ENG)
    http://www.xtremevbtalk.com/showthread.php?t=66994

    ADO Tutorial for Classic VB
    http://www.vbforums.com/showthread.php?t=551154

    Database Development FAQ
    http://www.vbforums.com/showthread.php?t=337051


  3. #3
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    It doesn't matter that you have a reference to ADO if you aren't using it.

  4. #4
    Join Date
    Jun 2009
    Posts
    135
    The problem I believe as I suggested to OP in another forum is the outdated DAO DATA1 control the OP is using. DAO 3.51 in itself should be able to open a 2k database, if not, 3.6 will.



    Good Luck

  5. #5
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    DAO, of any version, should not be used. It isn't that much of a task to convert existing projects to ADO.

  6. #6
    Join Date
    Mar 2008
    Posts
    111
    I have had try ADO 2.8 and DAO 3.6. It's still warning on

  7. #7
    Join Date
    Jun 2009
    Posts
    135
    DAO will be around until the end of Win7 support cycle (at least) and so I ask, why not! DAO=JET=ADO drivers for isam dbs...

  8. #8
    Join Date
    Mar 2009
    Location
    Italy - Breganze (VI)
    Posts
    120
    Quote Originally Posted by Hack View Post
    DAO, of any version, should not be used. It isn't that much of a task to convert existing projects to ADO.
    I agree 100%

    Convert database created in earlier versions of Access to Access 2002
    http://support.microsoft.com/kb/319400/en-us

    INFO: Issues Migrating from DAO/Jet to ADO/Jet
    http://support.microsoft.com/kb/225048/en-us


  9. #9
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Quote Originally Posted by vb5prgrmr View Post
    DAO will be around until the end of Win7 support cycle (at least) and so I ask, why not! DAO=JET=ADO drivers for isam dbs...
    Horses will no doubt be around until the end of time, but that doesn't mean they are the prefered method of transportation.

  10. #10
    Join Date
    Jun 2009
    Posts
    135

Similar Threads

  1. Access 97 to 2000 Conversion Error
    By Michelle in forum VB Classic
    Replies: 8
    Last Post: 04-19-2002, 05:01 PM
  2. Trying to open up an Access file.
    By Doug in forum VB Classic
    Replies: 2
    Last Post: 01-17-2002, 02:05 PM
  3. Replies: 2
    Last Post: 01-02-2002, 11:23 AM
  4. NullPointerException when reading text file
    By Andrew McLellan in forum Java
    Replies: 3
    Last Post: 05-09-2001, 05:34 PM
  5. ADO Connection to Access 2000 Database File
    By Syed Khan in forum VB Classic
    Replies: 2
    Last Post: 03-07-2001, 09:19 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