| Applies To | |
| Product(s): | Plant Project Tools |
| Version(s): | N/A |
| Environment: | Windows XP (32 bit) | Windows 7 (32 bit/64 bit) |
| Area: | N/A |
| Subarea: | N/A |
| Original Author: | Artiom Jakubovic, Bentley Product advantage Group |
Problem Description
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
Reason
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.
Steps To Resolve
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.
communities.bentley.com/.../3666.MS-Access1.flv
Additional information
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.
See Also
msdn.microsoft.com/.../jj618413.aspx
Comments or Corrections?
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!