I am learning to push tables from Access 2010 up to SQL Server (2005). When I "upsize" a table, Access shows the table linked. This means I can no longer run ALTER TABLE queries.
I have read some threads which say "Upsizing is a one-time deal, you should not need to alter...." In my case, it is not a one-time deal. What is the best practice for altering tables which have already been pushed to SQL Server?
I localized the table, altered the table, then tried upsizing again. But the wizard will not allow me to overwrite a table which exists in SQL Server. Should I just delete the table in SQL Server every time?
I have read some threads which say "Upsizing is a one-time deal, you should not need to alter...." In my case, it is not a one-time deal. What is the best practice for altering tables which have already been pushed to SQL Server?
I localized the table, altered the table, then tried upsizing again. But the wizard will not allow me to overwrite a table which exists in SQL Server. Should I just delete the table in SQL Server every time?