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

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lior Bobrov" wrote in message
...
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 .

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 .

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" wrote in message
...
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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lior Bobrov" wrote in message
...
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 .

Thanks for posting the solution.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lior Bobrov" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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