Results 1 to 6 of 6

Thread: Access 2000

  1. #1

    Thread Starter
    Member
    Join Date
    Dec 2005
    Posts
    63

    Access 2000

    I have a problem making a Data Base Application. I am using Access 2000 and VB6 but I am getting an error message that says "Unrecognized Database Format".

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: Access 2000

    Welcome to the forums.

    If you are using Access 2000, then my guess would be that the database you are using was probably made in Access 97 or earlier.

  3. #3
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Access 2000

    Normally Access 2K can open a 97 db, usually prompting you to convert it to 2K. Not sure if connecting through VB behaves differently, or what a pre=97 db would do. I typically see the "Unrecognized..." error when trying to open a later db version in an earlier one, i.e., opening a 2K db in 97. Besides Hack's answer, was the db created in Access 2003 or later?
    Access 2000 also uses ADO by default, not DAO. If you're using DAO code in your VB6 app, you're likely to get an error.
    Tengo mas preguntas que contestas

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

    Re: Access 2000

    Er... ADO / DAO doesn't matter - uses both (create a new mdb and check the references.

    I think you meant that if you are using vb the dao referenced may be the older one (3.5?) instead of 2003's one (3.6?).

    If you are using ADO - check your connection string.

    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...

  5. #5
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: Access 2000

    I thought 97 used DAO, 2K used ADO (unless you referenced DAO), and above that both are present by default. But the only VB versions I've used in a long time is .Net & VBA.
    Tengo mas preguntas que contestas

  6. #6
    Banned randem's Avatar
    Join Date
    Oct 2002
    Location
    Maui, Hawaii
    Posts
    11,385

    Re: Access 2000

    Qualinwraith,

    You need to use the appropiate connection string. What does your connection string look like.

    salvelinus,

    You can use ADO or DAO with either database.

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