New to Access Projects

[Mike Varigos]

Hi all,
Just looking for a good beginner reference book to allow
me to utilise the most of Access Data Project files, with
an SQL Server 7 Backend. Do I need to know SQL Server to
get by. My SQL knowledge is Intermediate and and my Access
Databasing skill are pretty good. VBA is SO-SO. I have
just purchased the Wrox Professional SQL Server
Development with Access 2000 by Rick Dobson and friends...
Any good? Any Suggestions?

TIA
Mike V

 

[dandgard]

It doesn't hurt to know SQL Server - but you can probably get by withou
any knowledge of it. You have to know how to connect to the DB - bu
any ODBC connectivity example should show you how to do that, and som
of the SQL statements have different parameters than in Access but the
should become evident very quickly.

Other than that the backend db should be pretty much tranparent to you

 

[dandgard]

It doesn't hurt to know SQL Server - but you can probably get by withou
any knowledge of it. You have to know how to connect to the DB - bu
any ODBC connectivity example should show you how to do that, and som
of the SQL statements have different parameters than in Access but the
should become evident very quickly.

Other than that the backend db should be pretty much tranparent to you

 

[Kevin3NF]

My experience with ADPs is this: the more SQL Server you know, the better
off you will be.

I hired an Access guru that wanted to learn more SQL Server and he screwed
my whole project due to lack of knowledge. I replaced him with a SQL
Server/Access guy, and he saved the day. He has had to create UDFs, stored
procs out the wazoo, etc.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.