I am developing an app in Access 2010 for a client that will eventually be run on SQL server. In the accdb 'options' I checked the option to make Queries, SQL Server Compatable.
I have SQL Server installed on my machine but have not used it for anything yet.
I have never gone thru the 'upsize' process before and need guidance from someone that has gone thru the process. I see the 'SQL Server' button and have clicked it. I know I will have to tell it where SQL server is, the password etc..
What are the undocumented problems that I will encounter?
Once I get past that, 'Is it magic'? Will a SQL server database be created, linked to my database with all of my tables, indexes etc..?
Once upsized, if I want to add a new field to a table how will I do that?
How to add a new table? Will this all have to be done thru SQL Server?