Relationships with SQL backend / Access frontend

[templeowls]

Quick question...if use SQL server as a backend for my tables and then MS Access as a front end, where should I build out the tables' relationships? SQL Server or Access?



Thanks

[kd2017]

Do it in SQL server. access wont be able to enforce referential integrity.

For convenience purposes you can rebuild them in access as well. It'll be helpful if you're building queries in access' query designer so access will know how to the link the tables up. Other than that it doesn't matter if you do it in access.

[madpiet]

Quick question...if use SQL server as a backend for my tables and then MS Access as a front end, where should I build out the tables' relationships? SQL Server or Access?

Thanks

I'd do it in SQL Server. Then it will *always* be enforced, no matter how you access the data. (Not even sure you can enforce it in Access)

[madpiet]

I'd do it in SQL Server. Then it will *always* be enforced, no matter how you access the data. (Not even sure you can enforce it in Access)

( I would also create my queries / stored procedures etc in SQL Server too... T-SQL has so many more options than Access, it's just not even funny)

[NoellaG]

For performance reasons there is not really a choice: SQL server.