Problem convert from MySQL to Access

[access man]

Dear all,

My company uses SQL DB to manage and run website. My department decided to use Acess database for internal using so we transferred the SQL DB to Access DB. I'm facing a problem that the tables and relationships look like very strange, different from what I know about AccessDB.

Let me say:
- Some of table have 02 primary keys!!! The database designer has put one more primary key due to languages. (please see the attachment picture
- The access database don't keep the relationships in the SQL server.

Please help me to solve this problem. Thanks in advance

Access man

 

[David Anderson]

I notice that you have had no replies to your post. This may be because you did not really ask a specific question. All you have said is that you find the existence of more than one primary key in a table to be "strange".

You don't say what version of Access you are using, but the online help in Access 2003 contains a description of when to use multiple-field primary keys. This can be a very useful feature.

If you say more clearly what you don't understand, you may get more replies.

David

 

[Moniker]

David is right in that you just seem confused, but there's no question asked. Multiple keys (called a composite key) are normal and can be rather useful. I wouldn't expect the relationships to come through completely intact because that's going to be the thing most unique between the structures. Just look at the relationships as they exist in the original DB and recreate that structure in Access. The queries, on the other hand, will probably need more reworking that the relationships.