By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,083 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

I will need a book.

P: n/a
I am lost with Access 2007... and I thought that it would be easier!

Don't get wrong. I am focused with Access 97. Although I worked in
2000/XP/2003, Access 97 was never far.

After 10 years, I am ready to rely on something newer. More of that
because Access 2007 will be available with free runtime versions (I
bought Sagekey+Wise, etc... for 97)

But geez, why does Access 2007 look so much more complicated?

Menus are loaded, confusing and not obvious. I know... I know...
you have to thing differently yada yada.... I am just not sure what
to think at this point.

I wished it would have been more obvious.

Feb 9 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
A book by authors I know and trust will be "Microsoft Access 2007 Inside
Out" by John Viescas and Jeff Conrad, published by Microsoft Press, but
according to Amazon, it will not be released until May 7.

I see a couple of books available now by authors I know and have read...
Michael Groh and Cary Prague are co-authors of "Access 2007 Bible" and Roger
Jennings has the latest edition of one I've recommended in the past,
"Special Edition Using Access 2007".

CAVEAT: I haven't seen or read any of these current editions, though, so I'd
just be going by my respect for those particular authors.

Larry
<sa******@hotmail.comwrote in message
news:11********************@v45g2000cwv.googlegrou ps.com...
>I am lost with Access 2007... and I thought that it would be easier!

Don't get wrong. I am focused with Access 97. Although I worked in
2000/XP/2003, Access 97 was never far.

After 10 years, I am ready to rely on something newer. More of that
because Access 2007 will be available with free runtime versions (I
bought Sagekey+Wise, etc... for 97)

But geez, why does Access 2007 look so much more complicated?

Menus are loaded, confusing and not obvious. I know... I know...
you have to thing differently yada yada.... I am just not sure what
to think at this point.

I wished it would have been more obvious.

Feb 9 '07 #2

P: n/a
On Feb 8, 7:28 pm, "saint...@hotmail.com" <saint...@hotmail.com>
wrote:
Don't get wrong. I am focused with Access 97. Although I worked in
2000/XP/2003, Access 97 was never far.

After 10 years, I am ready to rely on something newer.
Why Access?

It's not easily web-enabled.
Many cases of frequent corruption are reported.
Security is questionable.
MS has led us up some dead end roads with Access, viz ADPs and DAPs.
VBA lacks many capabilities, such as strong array handling procedures,
and its syntax is clumsy.
JET/ACE SQL remains very limited in what it can do.

Well, Access has a great reporting capability. And that's included in
the price. But even this is not easily ported to the net. Yes,
organizations want hard copy. But should they?

Why Access?

Feb 9 '07 #3

P: n/a
Where are you going with this? I love Access. Jet is very capable
and flexible for a *lot* of applications. The last corruption I got
must be more than 5 years. I am looking to Access 2007 just for a
wish of 'modernization' and let 97 go RIP.
Why Access?

It's not easily web-enabled.
Many cases of frequent corruption are reported.
Security is questionable.
MS has led us up some dead end roads with Access, viz ADPs and DAPs.
VBA lacks many capabilities, such as strong array handling procedures,
and its syntax is clumsy.
JET/ACE SQL remains very limited in what it can do.

Well, Access has a great reporting capability. And that's included in
the price. But even this is not easily ported to the net. Yes,
organizations want hard copy. But should they?

Why Access?

Feb 9 '07 #4

P: n/a
On Feb 8, 10:16 pm, "saint...@hotmail.com" <saint...@hotmail.com>
wrote:
Where are you going with this? I love Access. Jet is very capable
and flexible for a *lot* of applications.
I loved my 55 Chevy but not as much as my 67 Parisienne hardtop with
the 396 4 barrel (TTBOMR). I'd love to have either today as a toy, but
I wouldn't use it; my 4 cylinder Toyota is superior in almost every
way. Somewhere, maybe 1976, between the Parisienne and the Toyota a
model ended and I evaluated the choices available to me and left GM.
My question was about the possibility that when a new "model" of
Access comes out, we might upgrade to it without assessing our needs
and other technologies that might meet them, because it's comfortable.
You're reporting that you don't find Access 2007 to be comfortable. So
I ask, why not something else?

BTW my understanding of the Access 2007 "JET" is that it is a private
version called ACE, maintained by the Access team for Access 2007
only, and is not usable by other applications. The old JET that we
know and love has been part of Windows. Is it part of VISTA? I don't
know but it seems that it's days are numbered.

Feb 9 '07 #5

P: n/a
"Lyle Fairfield" <ly***********@aim.comwrote in
news:11**********************@v33g2000cwv.googlegr oups.com:
know but it seems that it's days are numbered.
its
Feb 9 '07 #6

P: n/a
On Feb 9, 12:25 am, "Lyle Fairfield" <lylefairfi...@aim.comwrote:
On Feb 8, 10:16 pm, "saint...@hotmail.com" <saint...@hotmail.com>
wrote:
Where are you going with this? I love Access. Jet is very capable
and flexible for a *lot* of applications.

I loved my 55 Chevy but not as much as my 67 Parisienne hardtop with
the 396 4 barrel (TTBOMR). I'd love to have either today as a toy, but
I wouldn't use it; my 4 cylinder Toyota is superior in almost every
way. Somewhere, maybe 1976, between the Parisienne and the Toyota a
model ended and I evaluated the choices available to me and left GM.
My question was about the possibility that when a new "model" of
Access comes out, we might upgrade to it without assessing our needs
and other technologies that might meet them, because it's comfortable.
You're reporting that you don't find Access 2007 to be comfortable. So
I ask, why not something else?

BTW my understanding of the Access 2007 "JET" is that it is a private
version called ACE, maintained by the Access team for Access 2007
only, and is not usable by other applications. The old JET that we
know and love has been part of Windows. Is it part of VISTA? I don't
know but it seems that it's days are numbered.
The last time I was in Toronto I saw a large Toyota sign from the
QEW. It would be wise to find out which Toyota models have assembly
lines in Canada since your retirement is financed by Canadian
workers :-). In the U.S. I believe that Honda and Toyota products
have higher percentages of U.S. parts than GM so the slogan "buy
American-made" doesn't mean quite the same thing it did a few years
ago.

In:

http://groups.google.com/group/comp....a04f8f17dcaac0

you mention that you are using Visual Web Developer 2005 Express
Edition.

In that case, maybe a better analogy would be in comparing car models
rather than car companies since you haven't really changed car
companies.

In terms of database technologies, which one is your Toyota? Is
Access your GM? What's your Honda? Your Kia?

Ignoring ACE's application-centric implementation temporarily, how
express is Web Express compared to developing in Access?

Also, I note that many new technologies are coming out. Some were
even purchased by your car company (I believe Groove was purchased by
MS). Many of the new technologies are free for initial development,
but you have to watch out for that balloon payment that your customer
will face eventually, especially with portal software.

I have another, somewhat OT question. Do you prefer security to be
service implemented or to be implemented at a SQL Server level when
using web enabled technologies?

As usual, I look forward to your comments.

James A. Fortune
CD********@FortuneJames.com

Feb 9 '07 #7

P: n/a
CD********@FortuneJames.com wrote in
news:11**********************@m58g2000cwm.googlegr oups.com:
On Feb 9, 12:25 am, "Lyle Fairfield" <lylefairfi...@aim.comwrote:
>On Feb 8, 10:16 pm, "saint...@hotmail.com" <saint...@hotmail.com>
wrote:
Where are you going with this? I love Access. Jet is very
capable and flexible for a *lot* of applications.

I loved my 55 Chevy but not as much as my 67 Parisienne hardtop with
the 396 4 barrel (TTBOMR). I'd love to have either today as a toy,
but I wouldn't use it; my 4 cylinder Toyota is superior in almost
every way. Somewhere, maybe 1976, between the Parisienne and the
Toyota a model ended and I evaluated the choices available to me and
left GM. My question was about the possibility that when a new
"model" of Access comes out, we might upgrade to it without assessing
our needs and other technologies that might meet them, because it's
comfortable. You're reporting that you don't find Access 2007 to be
comfortable. So I ask, why not something else?

BTW my understanding of the Access 2007 "JET" is that it is a private
version called ACE, maintained by the Access team for Access 2007
only, and is not usable by other applications. The old JET that we
know and love has been part of Windows. Is it part of VISTA? I don't
know but it seems that it's days are numbered.

The last time I was in Toronto I saw a large Toyota sign from the
QEW. It would be wise to find out which Toyota models have assembly
lines in Canada
Corolla and Solara models are assembled in Cambridge. One of Toyota's
trucks will or has recently joined this duo, I believe.

since your retirement is financed by Canadian
workers :-).
My retirement is not financed by Canadian Workers. All my princely
federal pensions are clawed back (this is a reward to the thrifty and the
wise). I have contributed heavily (6% - 9 % of my gross annual income
every year for 35 years) to any other pension funds from which I may
receive benefits. The Ontario Government, in charge of these funds lent
them to itself at 3% for most of these years, when the going rate was 8 -
10%. I do contribute between 20000 and 30000 CAD each year to the general
welfare through income tax, several thousand more in GST and PST and 7000
in property tax; I suppose all Canadians, including Canadian workers,
benefit from the taxes. Possibly some do not actually pay any. I have
apologised to the federal, provincial and municipal governments many
times for being successful, but they have all remained steadfast in their
determination to punish this behaviour.
In the U.S. I believe that Honda and Toyota products
have higher percentages of U.S. parts than GM so the slogan "buy
American-made" doesn't mean quite the same thing it did a few years
ago.
Sure it does. It means buy a poorly designed unreliable vehicle ...
always has. When the union cries the blues I like to tell the story of
watching Fords come off the assembly line (in Dearborn?) in 1965. The car
jockey spun the wheels for about 50 feet every time. Everyone watching
seemed to raise their eyebrows. I asked the executive showing me around
if this was good for business and why someone didn't tell the guy to
smarten up. He said something like, "We can't do anything about it
because of our agreements with the Union". And I never bought a Ford car
afterwards (but I did win one, a 1994 Windstar van; at 50000 km,
everything broke; Ford did $17000 warranty work; then I traded the
vehicle on a Toyota van; it's still running ... no repairs yet, oh wait
.... we had to replace a cable to the rear hatch lock because of rust.)
I'm all in favour of unions and think they have done wonderful work and
are indispensable to social fairness. Eugene V Debs is one of my heroes.
But that takes second place to my reluctance to being screwed around.
>
In:

http://groups.google.com/group/comp....rowse_frm/thre
ad/43a04f8f17dcaac0

you mention that you are using Visual Web Developer 2005 Express
Edition.

In that case, maybe a better analogy would be in comparing car models
rather than car companies since you haven't really changed car
companies.
True. But often I use DreamWeaver. I am victim to greener grass on the
other side of the fence every couple of weeks... always have been.
In terms of database technologies, which one is your Toyota? Is
Access your GM? What's your Honda? Your Kia?
I experimented with SQLite a few weeks ago. It seemed pretty Honda-ish to
me ... high rpms and I couldn't sit up straight in the driver's seat.
Ignoring ACE's application-centric implementation temporarily, how
express is Web Express compared to developing in Access?
Web Express is sort of like molasses in January compared with Access as
deprived of sex rabbit ejaculation.
>
Also, I note that many new technologies are coming out. Some were
even purchased by your car company (I believe Groove was purchased by
MS). Many of the new technologies are free for initial development,
but you have to watch out for that balloon payment that your customer
will face eventually, especially with portal software.

I have another, somewhat OT question. Do you prefer security to be
service implemented or to be implemented at a SQL Server level when
using web enabled technologies?
I have no solution to the security question. It worries me. Recently in
my applications I have built a false trail; that is a number of fairly
complex functions entitled "encrypt" and "decrypt" and "getPassword" etc,
which actually do something but not what one might think. I run another
concealed stratum of passwording, security, decryption etc.
>
As usual, I look forward to your comments.
You mean mindless rambling, I expect.
James A. Fortune
CD********@FortuneJames.com

Feb 9 '07 #8

P: n/a
On Feb 9, 3:43 pm, Lyle Fairfield <n...@thanks.comwrote:
in property tax; I suppose all Canadians, including Canadian workers,
benefit from the taxes. Possibly some do not actually pay any. I have
apologised to the federal, provincial and municipal governments many
times for being successful, but they have all remained steadfast in their
determination to punish this behaviour.
Ha! I really shouldn't be laughing but that is humorous.
You mean mindless rambling, I expect.
Thanks for sharing your experiences and opinions Lyle. Rambling --
yes, Mindless -- no, and not nearly as rambling as some posters here
although I nearly always learn much from sifting through some of the
novels.

James A. Fortune
CD********@FortuneJames.com

Feb 9 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.