Reading An Access Version 16 File

Anonymous
2023-11-02T20:39:58+00:00

I have been using the ACe drive for quite sometime now. All of a sudden I go to run a project that has been running and now crashes with

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I have the full office package installed which includes MSAccess, the verion is Microsoft® Access® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit. I am running the application in 64 Bit Mode, and yes I have tried it in 32bit modes as well...same error. Checking my registry reveals that this driver should be available. I see the old DAO is no longer supported. Is there something else we are supposed to use??? my connection string is as follows...

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\sessionWork-0\Data Processing\database.accdb

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 No comments

1 answer

Sort by: Most helpful
  1. George Hepworth 22,870 Reputation points Volunteer Moderator
    2023-11-02T20:50:31+00:00

    Is it possible the network location of your target accdb has been changed?

    Was this answer helpful?

    0 comments No comments