473,811 Members | 3,241 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Book advice

Mo
Hello All,

I'm investigating moving some Access 2003 applications over to SQL
Server 2005, using Access ADP as the front-end. It's would also be very
important to use stored procedures and unbound Access forms. I don't
really need help on stored procedures or SQL server specifically, more
how to implement the particular scenario I outlined

Are there any books/internet resources out there that people would
recommend?

Any help would be much appreciated.

TIA.
Oct 20 '08
14 1542
"Larry Linson" <bo*****@localh ost.notwrote in
news:vR******** ********@nwrddc 02.gnilink.net:
In fact, I thought you had given up on them for (in-)security reasons
-- did I misunderstand?
I did until I realized that mdb/accdb -odbc -ms-sql server applications
had the same insecurity. The insecurity exists because MS has not perfected
the use of application roles in Access. It's more glaring with ADPS, but
it's the same insecurity.
And, I do know that the Access team at Microsoft now recommends ACCDB
- ODBC - Server as the method of choice, not ADP as was the case for
several years.
My own opinion, shared by no one, I expect, is that the MS's abject and
almost total failure in enabling the easy and efficient use of application
roles by access applications is the reason for this, and for the
abandonment of any actice promotion of ADPs. It's one thing to have
enormous security holes that are a bit concealed, as in mdb/accdb -odbc
-ms-sql server applications and it's another to have them dangle in the
open in flashing neon as they do in ADPs. Regardless, it's the developer
who must assume responsibility for this insecurity as MS ignores the issue
and creates pretty ribbons, like HIV with sexier lipstick.

BTW, did the Access team create/approve/promote Northwoods 2007.accdb? Oh
yeah, I wanna accept recommendations from them, second only to
recommendations from the world's complete collection of buckets of rocks.

---
This question has bothered me for a long time, Larry. Perhaps you can help
with it?

If MVPs had been charged with the responsibility of pursuing the Iraq war,
would they have recommended using elephants because of Hannibal's success?

--
lyle fairfield
Oct 24 '08 #11
rkc
On Oct 23, 10:51*pm, lyle fairfield <lylef...@yah00 .cawrote:
"Larry Linson" <boun...@localh ost.notwrote innews:vR****** **********@nwrd dc02.gnilink.ne t:
In fact, I thought you had given up on them for (in-)security reasons
-- did I misunderstand?

I did until I realized that mdb/accdb -odbc -ms-sql server applications
had the same insecurity. The insecurity exists because MS has not perfected
the use of application roles in Access. It's more glaring with ADPS, but
it's the same insecurity.
And, I do know that the Access team at Microsoft now recommends ACCDB
- ODBC - Server as the method of choice, not ADP as was the case for
several years.

My own opinion, shared by no one, I expect, is that the MS's abject and
almost total failure in enabling the easy and efficient use of application
roles by access applications is the reason for this, and for the
abandonment of any actice promotion of ADPs. It's one thing to have
enormous security holes that are a bit concealed, as in mdb/accdb -odbc
-ms-sql server applications and it's another to have them dangle in the
open in flashing neon as they do in ADPs. Regardless, it's the developer
who must assume responsibility for this insecurity as MS ignores the issue
and creates pretty ribbons, like HIV with sexier lipstick.

BTW, did the Access team create/approve/promote Northwoods 2007.accdb? Oh
yeah, I wanna accept recommendations from them, second only to
recommendations from the world's complete collection of buckets of rocks.

---
This question has bothered me for a long time, Larry. Perhaps you can help
with it?

If MVPs had been charged with the responsibility of pursuing the Iraq war,
would they have recommended using elephants because of Hannibal's success?

--
lyle fairfield
Oct 24 '08 #12
"lyle fairfield" <ly******@yah00 .cawrote
BTW, did the Access team create/approve/
promote Northwoods 2007.accdb?
I don't know who wrote, or approved, any version of that example. I would
be even less likely to know about a 2007 version than earlier ones, but
don't know about either.

On occasion, I have recommended examining some particular small piece of
Northwind Traders to illustrate some technique.

Fortunately, rating application programs in general is not one of my
hobbies. :-)
If MVPs had been charged with the
responsibility of pursuing the Iraq war,
would they have recommended using
elephants because of Hannibal's success?
I wouldn't recommend using Microsoft MVPs to conduct a war anymore than I
would recommend using professional soldiers to create computer applications.

I would not care to speculate what any individual MVP might do in such a
circumstance, much, much less what they might do "on the average".

Larry
Nov 7 '08 #13
On Oct 23, 9:51 pm, lyle fairfield <lylef...@yah00 .cawrote:
"Larry Linson" <boun...@localh ost.notwrote innews:vR****** **********@nwrd dc02.gnilink.ne t:
In fact, I thought you had given up on them for (in-)security reasons
-- did I misunderstand?

I did until I realized that mdb/accdb -odbc -ms-sql server applications
had the same insecurity. The insecurity exists because MS has not perfected
the use of application roles in Access. It's more glaring with ADPS, but
it's the same insecurity.
And, I do know that the Access team at Microsoft now recommends ACCDB
- ODBC - Server as the method of choice, not ADP as was the case for
several years.

My own opinion, shared by no one, I expect, is that the MS's abject and
almost total failure in enabling the easy and efficient use of application
roles by access applications is the reason for this, and for the
abandonment of any actice promotion of ADPs. It's one thing to have
enormous security holes that are a bit concealed, as in mdb/accdb -odbc
-ms-sql server applications and it's another to have them dangle in the
open in flashing neon as they do in ADPs. Regardless, it's the developer
who must assume responsibility for this insecurity as MS ignores the issue
and creates pretty ribbons, like HIV with sexier lipstick.

BTW, did the Access team create/approve/promote Northwoods 2007.accdb? Oh
yeah, I wanna accept recommendations from them, second only to
recommendations from the world's complete collection of buckets of rocks.

---
This question has bothered me for a long time, Larry. Perhaps you can help
with it?

If MVPs had been charged with the responsibility of pursuing the Iraq war,
would they have recommended using elephants because of Hannibal's success?

--
lyle fairfield
While it's true that some MVP's supply canned responses without
engaging their brain sometimes and that it's true that the advice
given by some MVP's is often dated, realize that such inertia is not
necessarily a bad thing. The social inertia of any institution
eventually adapts to what is appropriate for that institution. BTW,
I'm not suggesting that MVP's belong in an institution :-). There are
signs that programming inertia is decreasing, resulting in more rapid
changes in how we program. Even some Microsoft specialists seem to be
struggling to keep up with the current rate of change. With their
affiliation with Microsoft I suspect that MVP's will soon experience
some of the culture shock that is happening there.

Right now I'm putting a lot of effort into becoming what I consider
proficient at C# and into watching the PDC 08 propaganda :-). I'm
also writing my Access programs so that they will convert to any
version of Access. I.e., I'm finding out what gets broken in A2K7 and
programming accordingly in a heterogeneous version environment.
That's just the Microsoft side.

IMO, Microsoft has made many mistakes as a result of moving too
quickly in some areas. Vista was ready (?) before the hardware
required to run it efficiently was in place at many companies. They
made many other mistakes by not thinking things through it would
seem. So I think social inertia has a reason for being what it is and
that programmers will get overwhelmed by some of the changes that are
coming. I suspect that if an MVP and Microsoft are at cross-purposes
such as competing for the same customer they'll find that Microsoft
won't be as nice to them as they would like. Microsoft is making a
very serious attempt to increase their competitiveness . IMO, it will
not be wise to remain ignorant of what Microsoft is developing. When
a customer sees what Microsoft is offering, we need to be able to
deliver a Microsoft solution if that is what they want.

We see many signs here that many Access programmers, including some
MVP's, are doing just that, yet they are also trying to retain enough
inertia so that they don't get whipsawed (a stock market term) by
adopting a technology too quickly that Microsoft later abandons. I
watched nearly all of the PDC 05 presentations and I think that will
help me place the PDC 08 presentations in context. I'm kind of
curious about what happened to WinFS.

I see myself getting busier and busier. There are still some loose
ends in some of my posts that I would like to tie up, but I'm going to
have to be selective about my efforts. For me the silver lining is
that the software industry requires a lot of knowledge and continual
learning effort. Anyone who succeeds at keeping up has a remarkable
advantage over, say, someone just starting out in the industry or even
someone with experience who does not have the opportunity or stamina
or vision to keep up. Yet we can't keep up with everything. Working
together and taking advantage of each other's strengths seems to be
the only way to obtain the software proficiency and quality we will
need given the difficulty of the task we will be facing. I appreciate
what I've learned from you, Lyle.

James A. Fortune
CD********@Fort uneJames.com

I've accomplished most of my goals in reading and posting to the
Access NG's. I've made people aware of my programming philosophy, my
strengths, my weaknesses, my coding style and my life in general --
all while helping people and learning as much as I can about Access.
While not perfect, Access has given me a framework (no pun intended)
for putting new software technologies into perspective. It's an
exciting time to be a programmer.
Nov 7 '08 #14
On Nov 6, 9:02*pm, "Larry Linson" <boun...@localh ost.notwrote:
"lyle fairfield" <lylef...@yah00 .cawrote

* BTW, did the Access team create/approve/
* promote Northwoods 2007.accdb?

I don't know who wrote, or approved, any version of that example. *I would
be even less likely to know about a 2007 version than earlier ones, but
don't know about either.

On occasion, I have recommended examining some particular small piece of
Northwind Traders to illustrate some technique.

Fortunately, rating application programs in general is not one of my
hobbies. :-)

* If MVPs had been charged with the
* responsibility of pursuing the Iraq war,
* would they have recommended using
* elephants because of Hannibal's success?

I wouldn't recommend using Microsoft MVPs to conduct a war anymore than I
would recommend using professional soldiers to create computer applications.

I would not care to speculate what any individual MVP might do in such a
circumstance, much, much less what they might do "on the average".

*Larry
Nov 7 '08 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

35
7929
by: Markus Dreyer | last post by:
I suggested our Librarian for the University Library to buy Accelerated C++. Practical Programming by Example. by Andrew Koenig and Barbara E. Moo http://www.acceleratedcpp.com/ but she replied saying it might be outdated, since it was published in 2000, and therefore not worth buying. I don't have the book, I just saw a lot of recommendations for it on the web. Do you think it's outdated? Is a new version planned? What is the best...
1
1273
by: Andreas Håkansson | last post by:
Hello, Does anyone have any advice on a good XPath book? Perhaps two books, one at a beginners/intermediate level and one advanced. While on the subject I wouldn't mind some advice on the same kind of books for XSLT. Cheers! =) ..Andreas
14
3520
by: __frank__ | last post by:
What do you think about the following book: "C How to Program", 4th edition, ISBN: 0131426443 I'm a novice. Thanks in advance.
11
3282
by: Robert Schuldenfrei | last post by:
I am an older person trying to learn C# just for the fun of it. I am a veteran of older style languages (COBOL, FORTRAN, etc.) and I want to learn an Object Orientated language. Currently working my way through Murach's C# by Joel Murach and Doug Lowe. Since I am not taking a course, I have no one to whom I can address questions. That is why I am turning to this newsgroup. Is this the best NG for a newbie like me? Are there people out...
2
1524
by: mesut demir | last post by:
Dear collegeaus, I would like to learn Visual Basic.NET and working with DATABASES. My intention is making some Windows programs using Database & Internet programs using Databaseses.(SQL) I'm a 3GL programmer.... Which and What book do you advice for start learning these stuffs? I have downloaded from Microsoft site:
3
1599
by: provowallis | last post by:
I'm new to this board so I hope this reqest isn't out of line, but I'm looking for some general advice about creating links in online books. If the link target didn't involve PIs I don't think I'd be here, but since it does, I'd be interested in getting some different perspectives on this. I have an XML book and I plan to create XHTML so I'm looking for the best way to create links from the various components of the book to the page...
11
1936
by: www.douglassdavis.com | last post by:
I'm looking for advice here, and I would really appreciate it if you could help. Is there a VB 2005 book that you like and would recommend (and why)? Would you consider it good for beginners to programming, intermediate, or advanced level?
3
1881
by: mesut | last post by:
Hi colleagues, I need your advice... I have approx 1,5 years experience with ASP.NET/VB.NET 2005 and I have to switch over into C# 2005 language. I don't have experience with C# 2005 language. (but 10 years experience in mainframe languagues). My question is: I need a good book can someone advice it? I'm only interested in ASP.NET not in windows pages.
3
2067
by: Chazam | last post by:
I am a C# programmer. I'm looking for a good book about .NET MOBILE development any advice. Thanks in advanced. I already post this on the mobile group like a week a go I think that group is dead. no one answer
76
4102
by: lorlarz | last post by:
Crockford's JavaScript, The Good Parts (a book review). This shall perhaps be the world's shortest book review (for one of the world's shortests books). I like Douglas Crockford (because I am a crabby old man too; plus he _is_ smart and good).. But, how can he write a book on the good parts of JavaScript and not mention functions that address CSS & DOM? Weird. It's like
0
9604
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10644
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10394
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9201
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7665
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6882
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5552
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5690
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
3015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.