ACC2000: A Microsoft Access Project Disconnects After You Open SQL Server Objects (313253)

SYMPTOMS

After you open an ADP file that appears to connect successfully, the ADP file disconnects after you open a table or a view. Additionally, you may receive one of the following error messages.

• When you create a new table
  You do not have exclusive access to the database at this time. Your design changes will not be saved.
  followed by:
  ADO Error: SELECT permission denied on object 'sysobjects', database '<DatabaseName>', owner '<OwnerName>'.
• When you create a new view:
  
  You do not have exclusive access to the database at this time. Your design changes will not be saved.
• When you create a new stored procedure:
  
  '<StoreProcedureName>' cannot be opened due to a dropped server connection.
• When you create a new database diagram:
  
  Cannot create objects of type 'Diagram' against current SQL backend. Please check your permissions and server setup.
• When you open 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 get one of these error messages, the Database window may display (Disconnected) in the title bar. However, forms may continue to work as usual.