Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Unrecognized database format (trying to connect to Access)

gemsemgemsem Posts: 7Member
I am trying to connect a VB6 RecordSource to an Access database and am getting the following "unrecognized database format" 'item'(Error 524) "the Specified error has occured in the Automation object currently running

Comments

  • ClanmanClanman Posts: 1Member
    : I am trying to connect a VB6 RecordSource to an Access database and am getting the following "unrecognized database format" 'item'(Error 524) "the Specified error has occured in the Automation object currently running
    :I got this message once, It was because the database field was formated differently to the data I was trying to insert e.g. field formated as a number and trying to put charecters in. Maybe this is your problem ?

  • kel1981bkel1981b Posts: 852Member
    : I am trying to connect a VB6 RecordSource to an Access database and am getting the following "unrecognized database format" 'item'(Error 524) "the Specified error has occured in the Automation object currently running
    :
    What control do you use DAO or ADO? If DAO, go to Properies window, check Connect property. If Access is selected and you use Access 2000, or Access 2000 is selected and you use Access, that may cause your problem. If you use ADO and Access 2000 check Microsoft Engine version, it must be 4.0.
    Hope this will help a little.
  • gemsemgemsem Posts: 7Member
    [b][red]This message was edited by gemsem at 2003-1-3 17:55:58[/red][/b][hr]
    : : I am trying to connect a VB6 RecordSource to an Access database and am getting the following "unrecognized database format" 'item'(Error 524) "the Specified error has occured in the Automation object currently running
    : :
    : What control do you use DAO or ADO? If DAO, go to Properies window, check Connect property. If Access is selected and you use Access 2000, or Access 2000 is selected and you use Access, that may cause your problem. If you use ADO and Access 2000 check Microsoft Engine version, it must be 4.0.
    : Hope this will help a little.
    :
    I am trying to use DAO, checked the Connect property, Access is selected but I am using Access 2000 (don't have the option to use Access 2000), how can I resolve this problem. Also how do you check the Engine version?


  • gemsemgemsem Posts: 7Member
    : : I am trying to connect a VB6 RecordSource to an Access database and am getting the following "unrecognized database format" 'item'(Error 524) "the Specified error has occured in the Automation object currently running
    : :
    : What control do you use DAO or ADO? If DAO, go to Properies window, check Connect property. If Access is selected and you use Access 2000, or Access 2000 is selected and you use Access, that may cause your problem. If you use ADO and Access 2000 check Microsoft Engine version, it must be 4.0.
    : Hope this will help a little.
    : Thank you, thank you, thank you, I went into Access help and found out how to convert an Access 2000 DBF to Access 97 and now I can connect

  • 25Bakang25Bakang Posts: 1Member
    : I am trying to connect a VB6 RecordSource to an Access database and am getting the following "unrecognized database format" 'item'(Error 524) "the Specified error has occured in the Automation object currently running

    :Easy Does it Man! Iwas "VICTIM" too -In short
    1. Open MS Access as normal
    2.In (File,Edit,View etc.)Menu Choose Tools.
    3 From Tools Select Database Utilities.
    4 Select Convert Database.
    5.Select To Prior Access Database Version.
    (The next step is so very important it hurts)
    6.Now Change the name of your Database to new one
    (e.g If Your name Was Dog you may change it to superDog etc)
    7.And then smile for it has been so easy!!)

    Regards

    Baks
    (It's soo nice,sunny,& warm in South Africa)


  • er1067er1067 Posts: 8Member
    Log on to micorsoft support and download service pack 4 or greater for visual. this will give you a reference tyo access 2000. if you just convert to an access 97 database, you will have to reconvert to make any changes and you'll loose your data.
  • arnarjarnarj Posts: 2Member
    I got this probblem once and i heard many ways to fix this.
    Bud the most simple one.

    Use Access 97, and you will not get this error message.
Sign In or Register to comment.