visibility to tables in an MS access ODBC

Frank Valendo 0 Reputation points
2026-09-11T13:42:40.8533333+00:00

I created an MS access ODBC data source. I cannot add tables. It allowed me to add one time, but now that option is not available. for existing or newly created ODBC

Microsoft 365 and Office | Access | Other | Windows

4 answers

Sort by: Newest
Most helpful Newest Oldest
  1. George Hepworth 23,120 Reputation points Volunteer Moderator
    2026-09-11T14:02:13.5266667+00:00

    Your follow up comment was hidden when I posted my first answer (a common problem here is the way comments and answers are interleaved and hard to follow).

    You said, "I am using the access ODBC to pull data using Crystal reports"

    Crystal reports is, as the name suggests a reporting tool. It uses data from a database source. So your clarification suggests that what you are doing is pulling data from an Access ACE engine for Crystal Reports. Is that correct? Or do you mean something different?

    Was this answer helpful?

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2026-09-11T13:56:03.7566667+00:00

    Your description leaves some questions.

    "I created an MS access ODBC data source." What, exactly, does this mean? Does it mean you created an accdb that uses ODBC to connect to tables in another "data source"? Or something else?

    "It allowed me to add one time, but now that option is not available." What indicator tells you the option is not available? HOW are you trying to add? And what, exactly, are you trying to add, additional tables?

    "for existing or newly created ODBC" What does this mean? ODBC is the protocol supporting connections. You don't "create and ODBC". You create connections using ODBC. Is that what you are trying to do, create additional ODBC connections? Or adding more tables using an existing ODBC connection? Or something else?

    Thanks for helping us understand the problem so we can help you.

    Was this answer helpful?

    0 comments

  4. AI answer

    2026-09-11T13:42:58.2133333+00:00

    If the Add Tables option was available once and is now missing for both existing and new ODBC sources in Access, check the ODBC data source configuration first.

    1. Verify the correct ODBC driver is installed.
      • Access requires the appropriate driver for the external database.
      • If the driver is missing or incorrect, table discovery can fail.
    2. Recreate or review the DSN in ODBC Data Source Administrator.
      • Open Control Panel > Administrative Tools > Data Sources (ODBC).
      • Check whether the DSN was created as User DSN, System DSN, or File DSN.
      • Select the DSN and review its settings.
      • Confirm the server name, database name, and authentication details are still correct.
    3. Make sure the DSN points directly to the target database.
      • A data source includes connection information such as server location, database name, logon ID, password, and driver options.
      • If the database setting is wrong, Access may connect but not show the expected tables.
    4. If using Azure SQL with Access, avoid older or incompatible SQL Server ODBC behavior.
      • One documented cause of missing tables is Access attempting to reference master.sysdatabases, which Azure SQL Database does not support.
      • In that case, use a modern SQL Server ODBC driver and configure the DSN to connect directly to the target database.
      • A reported workaround is to try ODBC Driver 17 if ODBC Driver 18 is not working correctly in Access.
    5. Re-add the data source if needed.
      • In Data Sources (ODBC), choose the DSN type, select Add, choose the correct driver, and complete the connection information.
      • This requires local administrator membership to add or configure an ODBC data source.
    6. If the issue started after it worked once, remove stale or unused DSNs.
      • In odbcad32, review both User DSN and System DSN.
      • Remove old entries that are no longer used, then restart Access and test again.

    If the environment is Azure SQL, the most likely fix is to create a DSN that is pinned to the target database and then link tables again from Access.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.