|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 27th, 2004, 02:21 AM
|
|||
|
|||
New to Access Projects
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 
|
|
#2
April 27th, 2004, 08:24 PM
|
|||
|
|||
|
New to Access Projects
It doesn't hurt to know SQL Server - but you can probably get by without any knowledge of it. You have to know how to connect to the DB - but any ODBC connectivity example should show you how to do that, and some of the SQL statements have different parameters than in Access but they should become evident very quickly. Other than that the backend db should be pretty much tranparent to you. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/
|
|
#3
April 27th, 2004, 08:24 PM
|
|||
|
|||
|
New to Access Projects
It doesn't hurt to know SQL Server - but you can probably get by without any knowledge of it. You have to know how to connect to the DB - but any ODBC connectivity example should show you how to do that, and some of the SQL statements have different parameters than in Access but they should become evident very quickly. Other than that the backend db should be pretty much tranparent to you. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/
|
|
#4
April 28th, 2004, 03:49 PM
|
|||
|
|||
|
New to Access Projects
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. "Mike Varigos" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
