Need help working from home with your Bentley software? We're here to help - click here
Error or Warning Message -
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.
Bentley's Product Advantage Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!