Hi Good day,
my Access database is about to reached the maximum capacity of 2GB. what i did to is used the Upsizing wizard default in MS Access to move all my table to SQL server.
I successfully migrated all my tables, but i'm struggling in changing all my pivot table data source from MS Access to SQL server.
i'm having this error. "you cannot choose a connection file that is incompatible with the existing connection".
all in all i have at least 100 pivot in place. and i don't like to re-work on this because i might forgot some formula in the existing one.
hope you can help me.
Thanks
rjbautista20