Share via

Excel 64bit with vba script can not load data from Access 32 bit database

Anonymous
2022-02-23T11:26:43+00:00

Hi, we have builded many years before some Excel file with vba code. This Excel file reads data from an Access database. In Office 32 bit everything was working fine. No we migrated to Office 64 bit and it is not working anymore. Now we have Excel 64 bits which is trying to read data from an Access 32 bit database. What is the best practice to fix this?

Microsoft 365 and Office | Access | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 40,206 Reputation points MVP Volunteer Moderator
    2022-04-19T14:39:19+00:00

    There is no automation between components of different bitness, in your case A-32 and E-64.

    If upgrading is not an option, Access can export to CSV file, and Excel can import that.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-04-19T11:41:51+00:00

    Hi. I have the same problem. Getting error 3024 when trying to

    Set db = Workspaces(0).OpenDatabase(Name:="c:\temp\Accessdatabase.mdb")

    .From an 32Bit Excel Version it works fine.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2022-02-23T13:24:25+00:00

    What code?

    Do you get any errors, which ones?.

    Why not install Access 64-bit if you're doing Access automation.

    Was this answer helpful?

    0 comments
  4. George Hepworth 22,855 Reputation points Volunteer Moderator
    2022-02-23T13:02:53+00:00

    "...it is not working anymore" What does that mean in this situation?

    Rather than statements about results, can you describe the actual behavior? What DOES happen? An error? Nothing?

    Was this answer helpful?

    0 comments