"unrecognized database format" in VB6.0 and Access 2002

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • qbsu21th
    New Member
    • Sep 2005
    • 1

    "unrecognized database format" in VB6.0 and Access 2002

    Dear Sir/Madam,

    I'm writing a small VB6.0 and Access 2002 application in XP OS. I selected the data control property RecordSource, I got the "Unrecogniz ed database format 'xxx/xx/*.mdb' " error. when run the application and double selected the *.mdb database, I got the same error. Why?

    I did converted the database file to access 2002. did i make any mistake when setup the reference or component?

    can anyone give a help as soon as possible?

    thanks,
    david
  • katended
    New Member
    • Nov 2005
    • 2

    #2
    unrecognized database format" in VB6.0 and Access 2002

    does the db openup in Access 2002? It it does then it must be okey, else
    try re-exporting the mdb . Also you need to recheck what provider u using, may be try using Microsoft Jet 3.51 OLE DB Provider while accessing the db

    Comment

    • chanchal_02
      New Member
      • Nov 2005
      • 2

      #3
      unrecognized database format......... .

      hi

      I have the same problem. if your problem has been solved, please help me.

      I'm using the same vb6.0 & access2002 using xp os.


      Originally posted by qbsu21th
      Dear Sir/Madam,

      I'm writing a small VB6.0 and Access 2002 application in XP OS. I selected the data control property RecordSource, I got the "Unrecogniz ed database format 'xxx/xx/*.mdb' " error. when run the application and double selected the *.mdb database, I got the same error. Why?

      I did converted the database file to access 2002. did i make any mistake when setup the reference or component?

      can anyone give a help as soon as possible?

      thanks,
      david

      Comment

      • chanchal_02
        New Member
        • Nov 2005
        • 2

        #4
        hi,

        I've the same problem.Can you help me out if yourproblem has been solved.

        please help me.

        Comment

        • jarvis79
          New Member
          • Apr 2006
          • 1

          #5
          Solved

          I've solved this problem by converting de database to acces97 format, this can be done by opening the database in your access 2000 or superior, menu tools, database utilities, then you have the option to change your db to access97 format.

          Comment

          • crazyware
            New Member
            • Jun 2006
            • 2

            #6
            Originally posted by jarvis79
            I've solved this problem by converting de database to acces97 format, this can be done by opening the database in your access 2000 or superior, menu tools, database utilities, then you have the option to change your db to access97 format.

            Actually this is not the correct soluton for your problem

            if you again use MSAccess above 2000 then you will get this problem again

            the correct solution is to install "VB SP6" (Service Pack 6)
            and you will never get the problem again
            you can download this at



            ok
            All the best

            Comment

            • sashi
              Recognized Expert Top Contributor
              • Jun 2006
              • 1749

              #7
              Hi there,

              another solution will be updating ur MDAC componenet to the latest one.. :) good luck my fren..

              Comment

              • Ali Rizwan
                Banned
                Contributor
                • Aug 2007
                • 931

                #8
                Originally posted by qbsu21th
                Dear Sir/Madam,

                I'm writing a small VB6.0 and Access 2002 application in XP OS. I selected the data control property RecordSource, I got the "Unrecogniz ed database format 'xxx/xx/*.mdb' " error. when run the application and double selected the *.mdb database, I got the same error. Why?

                I did converted the database file to access 2002. did i make any mistake when setup the reference or component?

                can anyone give a help as soon as possible?

                thanks,
                david

                Hello buddy

                First check your provider if it is 4.0 or 3.5 if it is 3.5 then set it to 4.0


                Use ADODC instead of using Data

                Comment

                Working...