when using SQL views, joining take place on the server which generally gives a better performance than locally by MSAccess queries. So you can replace your queries by SQLServer views...

Hi! If you have large linked tables and join them using queries in Access you can have a performance problem. You can try to use views on the server instead...

It disables @@DATEFIRST and it's only usable if Sunday is firstday. So not usable for me.

Hi Kathi,

the upsize wizard has been a great tool for me also, but I like to give a tip before you use it:

Be sure all tables have a primary key otherwise...