Relationships: Client or Server?
I have an Access database that I have successfully upsized to SQL Server 2005 Express. Needless to say, I had to re-create all the relationships by hand after I did the data migration (I tried using the Upsizing Wizard in Access but it always failed, giving no better explanation than "table was skipped, or export failed").
My question is this: now that the relationships live on the server, is it advantageous in any way to also leave them on the client? Might I gain some performance if I removed them from the client?