473,382 Members | 1,348 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

I will need a book.

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
8 1849
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
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
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
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
"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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Heber | last post by:
I looking for a source (book, on line tutorial, etc.) that will introduce me to writing programs that control my computer. For example, a program that enters bids on eBay automatically. Or a...
100
by: Peter | last post by:
Company thought DB2 will be better than Oracle. The bottom line is when you do select, the system crash. I think it may take 4-5 years for DB2 to reach Oracle standard. Peter
2
by: lagunasun | last post by:
not shitass responses. People like this david fellow, degrade the board. again, here is my msg, and thanks again for any assistance! I am going from learning c++ console apps to windows, and need...
11
by: Larry | last post by:
I will be teaching an eCommerce application development course using ASP.Net after many years of having taught classic ASP. (Course was interrupted by 18 months in the Middle East with my Army...
37
by: jasmith | last post by:
How will Access fair in a year? Two years? .... The new version of Access seems to service non programmers as a wizard interface to quickly create databases via a fancy wizard. Furthermore, why...
3
by: maria.metty | last post by:
Hello I am a student currently in an MIS program... Our teacher told us we don't need to know any scripting or coding to succeed in our job or program, but I still want to learn about coding......
19
by: Wessidemike | last post by:
Guys I'm new to web development and especially new to databases. I have no programing background but I am computer literate in other aspects. I'm trying to start a small online business dealing with...
1
by: Karthik01 | last post by:
Hi, I am using testcomplete 3.0 version.I'm trying to compare two xml's using DOM. My code uses getelementbytagname method.The lines of code are as below.It tries to fetch all the nodes with...
6
by: raylopez99 | last post by:
Will ASP.NET 3.0 work under Visual Studio 2005? And what is a good newbie ASP.NET book? Subject: Will ASP.NET 3.0 work under Visual Studio 2005? And what is a good newbie ASP.NET book? My...
1
by: ylekot88 | last post by:
Hello. Yes, I am a newbie to Javascripting for a whole 3 weeks now. I have been given an assignment in a book that is horribly worded, and I have spent about 30 hours trying to figure out what I am...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.