Access 2003 Table relationships - primary keys do not appear bold for me ...

[Allen Browne]

Perhaps someone else can suggest why you might be experiencing this problem.

In the mean time, are these:
- local Access tables (i.e. in this database)?
- attached Access tables (in another MDB)?
- attached tables from another database program? What?

If they are Access tables, is there anything that would prevent getting at
this info? For example, is the database secured?

You could always try unchecking the Name AutoCorrect boxes under:
Tools | Options | General | Name AutoCorrect
Then compact the database:
Tools | Database Utilities | Compact/Repair
If they are linked Access tables, do both actions in the back end as well.

One final alternative if they are Access tables might be to use this:
Relationship Report with extended field information
at:
http://allenbrowne.com/AppRelReport.html
The utility prints a "P" beside the primary key fields when you print the
relationships report.

 

[Lior Bobrov]

Hi ,

I added tables to the table-relationships window in Access 2003 .

According to web search , the primary keys in each table *should* appear in
bold .

However , they don't appear bold for me :
I can edit the relationships cardinalities (1 to 1 , 1 to N , M to N) ,
but the primary key fields look the same as the
other fields (one can't distinguish between the primary keys and the other
fields) .

In addition , I understood that even I print the relationships using
"printing relationships" option , the primary keys should
*not* appear bold ...

Thanks in advance ,
Lior .

 

[Lior Bobrov]

Problem solved already (few minutes ago) - the primary key was written in
Hebrew (like all the other fields) .
When writing the primary key field name in English , everything is alright ,
and all the primary keys are now bold !

Lior .

 

[Allen Browne]

Thanks for posting the solution.

It may help someone else with a right-to-left language.