Import database from MS SQL server to MS access

[StefanOl]

Dear Sir or Madame

I used Microsoft SQL Server Management Studio (and SQL express) to
create a database and then I "imported" it into MS access via linked tables.

This works very well, i can write and read data, I can change the tables and column names
in the SQL Management Studio and upadate the MS access linked tables via the "Linked Table Manager" in MS Access.

However, when I create relationships between the tables in the SQL Management Studio and
to a table update in MS access and look at the relationship diagram these new relationships are not visible ?

Is it so that MS access does not import the relationships created with the SQL Management Studio ?

Regards

 

[Guus2005]

I know what you mean. I had the same problem. But when you create a new query and select two tables you'll notice that the relations are there because they are created in/by the QBE. For some reason there are not shown in the Access relationship window.

HTH