I am trying to migrate my current CRM from access to sql server.
The problem is that I don't know whether to use Access Projects or use and ODBC connection from access to SQL.
If I use access projects then I don't have the functionalities that access provides like the Expresion Builder in forms and queries.
On the other hand if I simply use ODBC I will have compatibility problems for the different syntax and security features.
Also when I tried to upsize using the wizard I got a lot of errors regarding my queries and other stuff.