You may receive the following error message in Microsoft Access:
Microsoft Office Access can’t open the table in Datasheet view.
The Connect property of the table does not have enough information about the File DSN or the connection properties.
You may also receive the following error if you try to call an ODBC
[Microsoft][ODBC SQL Server Driver]Timeout expired (#o)
Ensure you are using the correct OBDC for your operating system. There is a Control Panel ODBC and one located in C:\Windows\SysWOW64\odbcad32.exe.
Try renaming the table you are getting the error on.
Set Microsoft Access to No Locks Option:
1. Start Microsoft Access.
2. Choose Tools > Options.
3. Click the Advanced tab.
4. In the Default open mode area, select the Shared option.
5 .In the Default record locking area, select the No Locks option.
Try specifying a machine DSN (User or System DSN) instead of a file DSN. See this article.