ACC2002: Microsoft Access Project Disconnects from SQL Server Shortly After It Opens (312281)

SYMPTOMS

After you open a Microsoft Access project (ADP) that appears to connect successfully, no tables or queries are visible in the Database window, and you may receive the following error messages:

• When you are creating a new table, a stored procedure, or a function:
  'ObjectName' cannot be created due to the project being disconnected.
  
  Use the Connection... command under the File menu to connect the project to a database.
• When you are creating a new view
  This version of Microsoft Access doesn't support design changes with the version of Microsoft SQL Server your project is connected to. See the Microsoft Office Update Web site for the latest information and downloads (on the Help menu, click Office on the Web). Your design changes will not be saved.
  followed by:
  ADO Error: SELECT permission denied on object 'SYSOBJECTS', database 'NorthwindCS', owner 'dbo'.
• When you are creating a new database diagram:
  
  Cannot create objects of type 'Diagram' against current SQL backend. Please check your permissions and server setup.
• When you are opening an existing report:
  
  The record source 'RecordsourceName' specified on this form or report does not exist.
  
  You misspelled the name, or it was deleted or renamed in the current database, or it exists in a different database.
  
  In the Form or Report's Design view, display the property sheet by clicking the Properties button, and then set the RecordSource property to an existing table or query.

After you receive one of these error messages, the Database window may display (Disconnected) in the title bar, and forms may continue to function.