Re: Migration from MS ACCESS MDB and Frontend

[Sebastien Caisse]

The relationships aren't exposed to MS Access. They (might) exist on the server but you don't see them. You can re-create them though (I did for my DB project). This is an ODBC driver issue (though I never really tested other DB solution which support exposing relationships to Access...) It should hopefully eventually be fixed, though don't hold your breath about that. 20 tables isn't THAT big so doing them manually shouldn't be too much trouble... Just make sure they do exist on the server side (which according to your lack of slowdowns probably means that they were indeed ported).

I don't really get the comment about data integrity (well, other then Access didn't corrupt anything like it hapenned to me) since his comment seems to be more applicable to the queries (used in the interface) then the actual data...