We have always used access for our databases.
Now they say we need sql.
I have messed with sql in the past. sql 2005 but really did not do
much.

They have some data in sql they want an access front end built for.
They then want to start converting our access databases to sql
backend.

Is there a book on doing this kind of thing.
Pitfalls and things watch out for or avoid doing?
something that gets detailed but still deals with this type of thing
in an easy to follow way.

thanks for any help with this

You're talking about "SQL Server 2005".

'SQL' - acronym for Structured Query Language - is used in most
databases since the 80s. So Ms Access is a SQL database along w/ a
bunch of others, including "SQL Server".

Just go to Amazon or Half.com and look up "SQL Server" and you will
find plenty of books.

Yep found 2.

they just installed sql server 2008 r2

On Wed, 27 Jul 2011 09:31:37 -0700 (PDT), "christianlott1 (AT) yahoo (DOT) com"
<christianlott1 (AT) yahoo (DOT) com> wrote: