I have been using MS Access, VBA & SQL within MS Access.

I now want to learn SQL server. Can anyone tell how this differes with Access SQL and can anyone recommend a book on SQL Server?

I like the "Microsoft Access Developer's Guide to SQL Server", by Chipman and Baron.

SQL Server is a high powered database program, Access utilizes the Jet database engine and is a rapid development table, forms and reporting tool. One commonly uses Access as a front end (program) with a SQL Server (data, backend). SQL Server has a very poor fronent capability. It does have a new Reporting Tool. For the price, Access offers both cheaply.

A good book is Access 2000 Client/Server Solutions, by Klender. Go to you local Barnes & Noble or Borders book store, or there equivalent to find what 'trick" you need. Amazon.com has both new and used books.

Many thanks for that.