There may be implicit relationships coded into the software without any relationships defined in the database schema, I have found that to be common in Access databases in the past (thankfully I no longer encounter them).

I'm with lensman; copy the schema and data into SQL Server and then set up indices and foreign key constraints.

Herbie