Datasheet

ErrorCode ErrorString

2637 Unable to start SQL Server service. To restart the SQL Server service,

double click on the SQL Server System Manager icon in the system

tray and click Start/Continue. Once the service is started, point to

Connection on the File menu in Access and click OK.

2638 Unable to start SQL Server service. To restart the SQL Server service,

double click on the SQL Server System Manager icon in the system

tray and click Start/Continue. If the service fails to start, go to the

Services console and verify that the MSSQLServer service Log On

information is correct. Once the service is started, point to Connection

on the File menu in Access and click OK.

2646 Microsoft Access can’t create this relationship and enforce referential

integrity. Data in the table ‘|’ violates referential integrity rules. For

example, there may be records relating to an employee in the Related

table, but no record for the employee in the primary table. Edit the data

so that records in the primary table exist for all related records. If you

want to create the relationship without following the rules of referential

integrity, clear the Enforce Referential Integrity check box.

2648 Microsoft Access created a one-to-one relationship instead of a one-to-

many relationship because there is a unique index on the field(s) speci-

fied for the related table. If you want to define a one-to-many

relationship between these tables, try one of the following:

• Delete the one-to-one relationship, and then change the setting of the

Indexed property for the foreign key field from No Duplicates to

Duplicates OK.

• Choose different matching fields.

2649 Microsoft Access can’t enforce referential integrity for this relation-

ship. Make sure the fields you drag are primary key fields or uniquely

indexed and that the unique index or primary key is correctly set. If

you want to create the relationship without following the rules of refer-

ential integrity, clear the Enforce Referential Integrity check box.

2650 Microsoft Access can’t create this relationship and enforce referential

integrity.

• The fields you chose may have different data types.

• The fields may have the Number data type but not the same FieldSize

property setting. Try one of the following:

• Select fields with the same data type.

• Open the tables in Design view, and change the data types and

field sizes so that the fields match.

Appendixes for Web Site

ART VI