Microsoft KB Archive/312281

= ACC2002: Microsoft Access Project Disconnects from SQL Server Shortly After It Opens =

Article ID: 312281

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q312281



Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).



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.



CAUSE
You do not have SELECT permissions on the SysObjects system table in the database. Access relies on the SysObjects table to determine what objects to display in the Database window and when it performs various tasks, such as opening reports.



RESOLUTION
Grant the user (or the Public database role) SELECT permission on the SysObjects system table in the database.



MORE INFORMATION
For more information about handling SQL Server security, please see to the SQL Server security articles at the following Microsoft Web site:

SQL Server 2000 Security

SQL Server 7.0 Security

Additional query words: prb adp disconnect

Keywords: kbprb KB312281

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.