I am working on upsizng our Access database to SQL server keeping Access as front end. I have experience some of the errors such as no index for the tables ...
Since it is still under processing, I cannot put it on sevice (letting user to update the data) while I am still doing the modification.
What is the best way to update the data in sql server when the modification is done? Some of the datatype is changed automatically when upsized to sql server, will it be a problem?
Since it is still under processing, I cannot put it on sevice (letting user to update the data) while I am still doing the modification.
What is the best way to update the data in sql server when the modification is done? Some of the datatype is changed automatically when upsized to sql server, will it be a problem?
