Access vs SQL

[Guest]

Our company recently rewrote/converted a large in-house Access 97 system to
SQL. I have written a few systems in Access but do not know the difference
between Access and SQL. If you know Access programming then is SQL just a
small progression as far as coding? Is SQL set up as a container the way
Access is? Where can I get more information about this?

Thanks,

Steven

 

[Ron Hinds]

There are some differences between Access SQL and T-SQL (used with SQL
Server). So most of your Access SQL experience will carry right over. As to
the second part of your question: SQL Server is a database engine *only* -
there is no UI associated with it. It would be the equivalent of a BE
database in a pure Access app. You still need to use something else as the
FE - Access, Visual Basic, etc. So there is no reason why Access cannot be
the "container", thus leveraging *all* of your current skill set. I
recommend you get this book: Microsoft Access Developer's Guide to SQL
Server by Chipman and Baron, SAMS Press. One of the authors, Mary Chipman,
is a frequent contributor to these newsgroups, too.

 

[Guest]

Thank you for the response.

Steven

There are some differences between Access SQL and T-SQL (used with SQL
Server). So most of your Access SQL experience will carry right over. As to
the second part of your question: SQL Server is a database engine *only* -
there is no UI associated with it. It would be the equivalent of a BE
database in a pure Access app. You still need to use something else as the
FE - Access, Visual Basic, etc. So there is no reason why Access cannot be
the "container", thus leveraging *all* of your current skill set. I
recommend you get this book: Microsoft Access Developer's Guide to SQL
Server by Chipman and Baron, SAMS Press. One of the authors, Mary Chipman,
is a frequent contributor to these newsgroups, too.