Hi,

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?

Thanks!

Aaron

I am not clear on your questions?, if you have already migrated to a server side database; this should be your best option. Remember that if you let the client create the relationship everything you call for data, the client has pull all information to the client local machine. The advantage of using the server side is you are allowing the process to process the information and the client will only receive the results. Server side process managed by the server and the databases engine is 98 percent more advantages the client side in almost all cases.

Jaime E. Maccou