Access cannot save the imports steps in last step of import extenal data

Question

When I use the import external data function of access, process with the last step, saving import steps, always shown the error message as below. When importing a single table, this error will disappear. but this error is reported for multiple tables, but I am not prompted how to specify the import ID name. Is there anyone tell me why?

And could you tell me how to resove another error as below ? It occurs every time I open my access file. Could tell me how to find the root reason about this error?

Answer 1

Dear Connie,

From your description, it seems that the issue happens when you import from multiple tables and you are using ODBC data. f yes, may I know whether the issue happens when you import from other data sources?

About the second issue, it seems that the message might appear if there is some code that is running when the app opens.

For your reference:the command or action requery isn't available - Access 2013 - - Microsoft Community

Access 2013 - Switchboard Error on Open - Microsoft Community

We will also keep the thread open and welcome other community members to share their suggestions and ideas.

Thanks for your effort and time.

Cliff

Answer 2

ODBC is our only data source. I can try to import a excel file for testing, that is ok. But it can be imported via single table only. And I wonder why my interface is different from the save import interface on the Microsoft Community.

"The command or action 'Requery' isn't available now" means cannot resolved in windows 10? Is it possbile rebuild the query to make the access file didn't show the message box.