Hi every one,

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.

I would appreciate your help.