You are currently reviewing an older revision of this page.
Microsoft Access can't find the object 'dbo.<table name>'
The Error message is shown while trying to access Table Design mode in AutoPlant Project Administrator. The AutoPlant project is using SQL database to store project data. In Project Administrator select Project Name>Database>Databases Node. Select PROJDATA in database list and click on Edit Tables… button. Select table, click Edit and then Table Design…
The Reason for this message is lost connection to SQL database in Projdata.adp file (Microsoft Access project file). This usually happens when SQL Server name is changed or project's database is moved to another SQL server.
In order to resolve and bring back Table Design functionality, go to Projdata folder in your PROJECT_ROOT and open Projdata.adp file. In MS Access 2010 go to File menu > Info > Server > Connection. Add correct information in Data Link Properties dialog. Below is a brief demonstration video with above described steps.
Starting from MS Access 2013 Access Data Projects (ADPs) are no longer supported, thus Table Design… through AutoPlant Project Administrator is no longer supported for project that are using SQL database to store data.