SQL

No changes needed, the same queries you use for access will work fine on ms sql but to get better performace and security you should use stored procedures

 

 

Edited by fernan82

The problems is that either you datatype is a fixed character firld type or was at one time. For example if you field is char or nchar  (50)  the entries are always 50 characters long. if it is e.g. varchar(50) it can be up to 50 but does not add spaces if it is shorter.
If you imported the data or changed the fieldtype from char to varchar at one point it keeps the spaces as SQL sees them as data. So if you you change you fieldtype to a variable type like varchar you can use a simple query to get rid of the spaces in your field.
Update tablename Set field = RTrim(field)

SQL Server has a Datatype called image which you could use to store I believe up to 2GB of data per field. Thus you might want to consider storing the file somewhere and just point to it from the db

The biggest differences between SQL and Access are:
1) date format and the date function. SQL surrounds dates with single quotes not #
2) stored procedures
3) the ability to return multiple recordsets with one call to the database.

#1 is important.
#2 can improve the efficiency of your application
#3 will improve the efficiency of your application