accdb vs adp

Perhaps you should shut up and learn how powerful it is-- instead of
making excuses?

Have you ever built a SQL Server UDF?

Let's say that "better support for UDFs and SQL Server" counts as
a "new
feature" and give you that one as well, although I was REALLY hoping
you'd
be able to identify an actual "feature",
and not just "better support" for existing functions.



On Feb 24, 10:18*pm, "GP George" wrote:
Confusion still reigns.

I suppose your claim that introducing ADPs in Access 2000 can be construed
as a "new" feature for ADPs is valid. You get a point there, and it is
actually kind of clever;
ADPs are in themselves a "new feature". Quite clever indeed. A new feature
by virtue of being new.

Let's say that "better support for UDFs and SQL Server" counts as a "new
feature" and give you that one as well, although I was REALLY hoping you'd
be able to identify an actual "feature",
and not just "better support" for existing functions.

Now we get to some interesting things. *"Pivot Tables" were a new ADP
feature in 2003? *I won't bet money on it, but I am pretty sure pivot table
support for ADPs was present in 2002.
Maybe you can pull a real citation from a recognized source *indicating that
they didn't appear in ADP's until the 2003 version? This is not a big deal,
but the point of this exercise was to
demonstrate your lack of attention to detail, and your inability to be
accurate. On that point, you didn't do so good here, did you?

The last two claimed features are, shall we say, marginal at best. Saying
that "SQL 2005, half dozen other features", *and "SQL 2008 support" *are
"new features"
in ADP's is really a stretch, is it not? Unless I have been seriously
misled, support for SQL Server is kind of the whole POINT for ADPs! *As a
matter of fact, and you may not recall this,
just over a year ago, you, yourself, actually submitted a comment in the
Access Team Blog in which you complained *about the lack of full support for
SQL Server 2008 in Access 2007!

That's right, you criticized MS Access development team on this very point.

David;

Just because you don't respect the new features in SQL Server, doesn't
mean it's not a few feature

Stuff like pivot keyword, stuff like being able to pass around table
variables-- it's priceless, kid!

-Aaron


On Feb 25, 9:15*am, "David W. Fenton"
wrote:
"a a r o n . k e m p f @ g m a i l . c o m"
wrote
m:

Access 2000 - First version
Access 2002 - better UDF / SQL Server support
Access 2003 - pivotTables
Access 2007 - SQL 2005, half dozen other features

Name 3 of them.

Access 2010 - SQL 2008 support

That's not an ADP feature at all. It constitutes no change to the
way ADPs work, just integration with the current version of SQL
Server. And, of course, the next version of SQL Server will negate
it (not that it even matters that much.

You neglect to mention in the first three versions of ADPs how many
things were broken, and then fixed, and then reverted. Steve
Jorgensen tried really hard to use ADPs, but as a moving target, and
with flaws with no real workarounds, he gave up. If somebody as
smart as Steve can't make them work, I *know* that *you* can't.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
usenet at dfenton dot com * *http://www.dfenton.com/DFA/

David;

why don't you stop harrassing me, and focus instead on shaking your
fist at the sky because they removed your precious Jet Replication

-Aaron



On Feb 25, 9:17*am, "David W. Fenton"
wrote:
"GP George" wrote :

You can do
better.

George, the sad thing is that Aaron *can't* do better.

There is simply no there there.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
usenet at dfenton dot com * *http://www.dfenton.com/DFA/

Thanks, Aaron.


"Working with an Access project is very similar to working with an Access
database. The process of creating forms, reports, data access pages, macros,
and modules is virtually the same as that used to create an Access database.

Once you connect to an SQL Server database, you can view, create, modify,
and delete tables, views, stored procedures, user-defined functions, and
database diagrams by using the Database Designer, Table Designer, Query
Designer, Query Builder, and SQL Text Editor. Although the user interface
for working with these database objects is different from the equivalent
database objects in an Access database, it is just as user-friendly. An
Access project also contains many of the same wizards as an Access database,
such as the Form Wizard, the Report Wizard, the Page Wizard, and the Input
Mask Wizard. These Wizards help you to quickly create a prototype or simple
application, and also make it easier to create an advanced application."

If anyone wants to know which version of Access that statement refers to,
you can use this link. (Hint, it is NOT Access 2007.)

http://office.microsoft.com/en-us/ac...731031033.aspx





"a a r o n . k e m p f @ g m a i l . c o m" wrote in
message
...
have you seen the form wizards in Access 2007?

is it not a new feature?

what are you talking about dude!??!!??!!!

you chastise me for describing the features in every version of
Access.. but the fact of the matter is that you're just ****ed off
because the facts contradict some of the BS that the MVPs claim.





On Feb 24, 10:36 pm, "GP George" wrote:
Good grief, Aaron, this is not good news for you, man. You are not even
consistent between two posts made minutes apart!

In this one you actually contradict your previous assertion that Pivot
tables were new in 2003. Okay, better late than never.

And I see that you are now listing "form wizards" for ADPs as a new
feature
in Access 2007. Do you REALLY want to make that claim?
Maybe you should back off on that one before someone posts the actual
citation showing it to be false.

Again, I assume you would like to be taken seriously, but that is
increasingly difficult to do. It might be smarter of you to just find
another way to release your angst.
Posting in the PNG's seems not to be a good strategy for you. There are,
for
example, classes in Yoga and meditation where you might learn to release
some of that stress in a healthier way.
It's just a thought. Best of luck with it in any event.

George

"a a r o n . k e m p f @ g m a i l . c o m" wrote
in
...

Access 2000 - First version
Access 2002 - pivotTables, better UDF / SQL Server support, more
powerful table designer
Access 2003 - XML (because SQL Server is VERY powerful with XML, this
is important), OWC performance improvements
Access 2007 - SQL 2005, half dozen other features (form wizards, etc)
Access 2010 - SQL 2008 support

What features did Access 2007 introduce for jet retards?
What features did Access 2003 introduce for jet retards?
What features did Access 2002 introduce for jet retards?
What features did Access 2000 introduce for jet retards?



On Feb 26, 6:35*pm, "GP George" wrote:
Thanks, Aaron.

"Working with an Access project is very similar to working with an Access
database. The process of creating forms, reports, data access pages, macros,
and modules is virtually the same as that used to create an Access database.

Once you connect to an SQL Server database, you can view, create, modify,
and delete tables, views, stored procedures, user-defined functions, and
database diagrams by using the Database Designer, Table Designer, Query
Designer, Query Builder, and SQL Text Editor. Although the user interface
for working with these database objects is different from the equivalent
database objects in an Access database, it is just as user-friendly. An
Access project also contains many of the same wizards as an Access database,
such as the Form Wizard, the Report Wizard, the Page Wizard, and the Input
Mask Wizard. These Wizards help you to quickly create a prototype or simple
application, and also make it easier to create an advanced application."

If anyone wants to know which version of Access that statement refers to,
you can use this link. (Hint, it is NOT Access 2007.)

http://office.microsoft.com/en-us/ac...731031033.aspx

"a a r o n . k e m p f @ g m a i l . c o m" wrote in
...



have you seen the form wizards in Access 2007?

is it not a new feature?

what are you talking about dude!??!!??!!!

you chastise me for describing the features in every version of
Access.. but the fact of the matter is that you're just ****ed off
because the facts contradict some of the BS that the MVPs claim.

On Feb 24, 10:36 pm, "GP George" wrote:
Good grief, Aaron, this is not good news for you, man. You are not even
consistent between two posts made minutes apart!

In this one you actually contradict your previous assertion that Pivot
tables were new in 2003. Okay, better late than never.

And I see that you are now listing "form wizards" for ADPs *as a new
feature
in Access 2007. Do you REALLY want to make that claim?
Maybe you should back off on that one before someone posts the actual
citation showing it to be false.

Again, I assume you would like to be taken seriously, but that is
increasingly difficult to do. *It might be smarter of you to just find
another way to release your angst.
Posting in the PNG's seems not to be a good strategy for you. There are,
for
example, classes in Yoga and meditation where you might learn to release
some of that stress in a healthier way.
It's just a thought. Best of luck with it in any event.

George

"a a r o n . k e m p f @ g m a i l . c o m" wrote
in
...

Access 2000 - First version
Access 2002 - pivotTables, better UDF / SQL Server support, more
powerful table designer
Access 2003 - XML (because SQL Server is VERY powerful with XML, this
is important), OWC performance improvements
Access 2007 - SQL 2005, half dozen other features (form wizards, etc)
Access 2010 - SQL 2008 support- Hide quoted text -

- Show quoted text -

Thanks, Aaron.

This is over now.


George

"a a r o n . k e m p f @ g m a i l . c o m" wrote in
message
...
What features did Access 2007 introduce for jet retards?
What features did Access 2003 introduce for jet retards?
What features did Access 2002 introduce for jet retards?
What features did Access 2000 introduce for jet retards?



On Feb 26, 6:35 pm, "GP George" wrote:
Thanks, Aaron.

"Working with an Access project is very similar to working with an Access
database. The process of creating forms, reports, data access pages,
macros,
and modules is virtually the same as that used to create an Access
database.

Once you connect to an SQL Server database, you can view, create, modify,
and delete tables, views, stored procedures, user-defined functions, and
database diagrams by using the Database Designer, Table Designer, Query
Designer, Query Builder, and SQL Text Editor. Although the user interface
for working with these database objects is different from the equivalent
database objects in an Access database, it is just as user-friendly. An
Access project also contains many of the same wizards as an Access
database,
such as the Form Wizard, the Report Wizard, the Page Wizard, and the
Input
Mask Wizard. These Wizards help you to quickly create a prototype or
simple
application, and also make it easier to create an advanced application."

If anyone wants to know which version of Access that statement refers to,
you can use this link. (Hint, it is NOT Access 2007.)

http://office.microsoft.com/en-us/ac...731031033.aspx

"a a r o n . k e m p f @ g m a i l . c o m" wrote
in
...



have you seen the form wizards in Access 2007?

is it not a new feature?

what are you talking about dude!??!!??!!!

you chastise me for describing the features in every version of
Access.. but the fact of the matter is that you're just ****ed off
because the facts contradict some of the BS that the MVPs claim.

On Feb 24, 10:36 pm, "GP George" wrote:
Good grief, Aaron, this is not good news for you, man. You are not
even
consistent between two posts made minutes apart!

In this one you actually contradict your previous assertion that Pivot
tables were new in 2003. Okay, better late than never.

And I see that you are now listing "form wizards" for ADPs as a new
feature
in Access 2007. Do you REALLY want to make that claim?
Maybe you should back off on that one before someone posts the actual
citation showing it to be false.

Again, I assume you would like to be taken seriously, but that is
increasingly difficult to do. It might be smarter of you to just find
another way to release your angst.
Posting in the PNG's seems not to be a good strategy for you. There
are,
for
example, classes in Yoga and meditation where you might learn to
release
some of that stress in a healthier way.
It's just a thought. Best of luck with it in any event.

George

"a a r o n . k e m p f @ g m a i l . c o m"
wrote
in
...

Access 2000 - First version
Access 2002 - pivotTables, better UDF / SQL Server support, more
powerful table designer
Access 2003 - XML (because SQL Server is VERY powerful with XML,
this
is important), OWC performance improvements
Access 2007 - SQL 2005, half dozen other features (form wizards,
etc)
Access 2010 - SQL 2008 support- Hide quoted text -

- Show quoted text -

What features did Access 2007 introduce for jet retards?
What features did Access 2003 introduce for jet retards?
What features did Access 2002 introduce for jet retards?
What features did Access 2000 introduce for jet retards?






On Feb 26, 8:14*pm, "GP George" wrote:
Thanks,Aaron.

This is over now.

George

"a a r o n.k e m p f@ g m a i l . c o m" wrote in
...



What features did Access 2007 introduce for jet retards?
What features did Access 2003 introduce for jet retards?
What features did Access 2002 introduce for jet retards?
What features did Access 2000 introduce for jet retards?

On Feb 26, 6:35 pm, "GP George" wrote:
Thanks,Aaron.

"Working with an Access project is very similar to working with an Access
database. The process of creating forms, reports, data access pages,
macros,
and modules is virtually the same as that used to create an Access
database.

Once you connect to an SQL Server database, you can view, create, modify,
and delete tables, views, stored procedures, user-defined functions, and
database diagrams by using the Database Designer, Table Designer, Query
Designer, Query Builder, and SQL Text Editor. Although the user interface
for working with these database objects is different from the equivalent
database objects in an Access database, it is just as user-friendly. An
Access project also contains many of the same wizards as an Access
database,
such as the Form Wizard, the Report Wizard, the Page Wizard, and the
Input
Mask Wizard. These Wizards help you to quickly create a prototype or
simple
application, and also make it easier to create an advanced application.."

If anyone wants to know which version of Access that statement refers to,
you can use this link. (Hint, it is NOT Access 2007.)

http://office.microsoft.com/en-us/ac...731031033.aspx

"a a r o n.k e m p f@ g m a i l . c o m" wrote
in
...

have you seen the form wizards in Access 2007?

is it not a new feature?

what are you talking about dude!??!!??!!!

you chastise me for describing the features in every version of
Access.. but the fact of the matter is that you're just ****ed off
because the facts contradict some of the BS that the MVPs claim.

On Feb 24, 10:36 pm, "GP George" wrote:
Good grief,Aaron, this is not good news for you, man. You are not
even
consistent between two posts made minutes apart!

In this one you actually contradict your previous assertion that Pivot
tables were new in 2003. Okay, better late than never.

And I see that you are now listing "form wizards" for ADPs *as a new
feature
in Access 2007. Do you REALLY want to make that claim?
Maybe you should back off on that one before someone posts the actual
citation showing it to be false.

Again, I assume you would like to be taken seriously, but that is
increasingly difficult to do. *It might be smarter of you to just find
another way to release your angst.
Posting in the PNG's seems not to be a good strategy for you. There
are,
for
example, classes in Yoga and meditation where you might learn to
release
some of that stress in a healthier way.
It's just a thought. Best of luck with it in any event.

George

"a a r o n.k e m p f@ g m a i l . c o m"
wrote
in
...

Access 2000 - First version
Access 2002 - pivotTables, better UDF / SQL Server support, more
powerful table designer
Access 2003 - XML (because SQL Server is VERY powerful with XML,
this
is important), OWC performance improvements
Access 2007 - SQL 2005, half dozen other features (form wizards,
etc)
Access 2010 - SQL 2008 support- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What features did Access 2007 introduce for jet retards?
What features did Access 2003 introduce for jet retards?
What features did Access 2002 introduce for jet retards?
What features did Access 2000 introduce for jet retards?






On Feb 26, 8:14*pm, "GP George" wrote:
Thanks, Aaron.

This is over now.

George

"a a r o n . k e m p f @ g m a i l . c o m" wrote in
...

What features did Access 2007 introduce for jet retards?
What features did Access 2003 introduce for jet retards?
What features did Access 2002 introduce for jet retards?
What features did Access 2000 introduce for jet retards?

On Feb 26, 6:35 pm, "GP George" wrote:
Thanks, Aaron.

"Working with an Access project is very similar to working with an Access
database. The process of creating forms, reports, data access pages,
macros,
and modules is virtually the same as that used to create an Access
database.

Once you connect to an SQL Server database, you can view, create, modify,
and delete tables, views, stored procedures, user-defined functions, and
database diagrams by using the Database Designer, Table Designer, Query
Designer, Query Builder, and SQL Text Editor. Although the user interface
for working with these database objects is different from the equivalent
database objects in an Access database, it is just as user-friendly. An
Access project also contains many of the same wizards as an Access
database,
such as the Form Wizard, the Report Wizard, the Page Wizard, and the
Input
Mask Wizard. These Wizards help you to quickly create a prototype or
simple
application, and also make it easier to create an advanced application.."

If anyone wants to know which version of Access that statement refers to,
you can use this link. (Hint, it is NOT Access 2007.)

http://office.microsoft.com/en-us/ac...731031033.aspx

"a a r o n . k e m p f @ g m a i l . c o m" wrote
in
...

have you seen the form wizards in Access 2007?

is it not a new feature?

what are you talking about dude!??!!??!!!

you chastise me for describing the features in every version of
Access.. but the fact of the matter is that you're just ****ed off
because the facts contradict some of the BS that the MVPs claim.

On Feb 24, 10:36 pm, "GP George" wrote:
Good grief, Aaron, this is not good news for you, man. You are not
even
consistent between two posts made minutes apart!

In this one you actually contradict your previous assertion that Pivot
tables were new in 2003. Okay, better late than never.

And I see that you are now listing "form wizards" for ADPs *as a new
feature
in Access 2007. Do you REALLY want to make that claim?
Maybe you should back off on that one before someone posts the actual
citation showing it to be false.

Again, I assume you would like to be taken seriously, but that is
increasingly difficult to do. *It might be smarter of you to just find
another way to release your angst.
Posting in the PNG's seems not to be a good strategy for you. There
are,
for
example, classes in Yoga and meditation where you might learn to
release
some of that stress in a healthier way.
It's just a thought. Best of luck with it in any event.

George

"a a r o n . k e m p f @ g m a i l . c o m"
wrote
in
...

Access 2000 - First version
Access 2002 - pivotTables, better UDF / SQL Server support, more
powerful table designer
Access 2003 - XML (because SQL Server is VERY powerful with XML,
this
is important), OWC performance improvements
Access 2007 - SQL 2005, half dozen other features (form wizards,
etc)
Access 2010 - SQL 2008 support- Hide quoted text -

- Show quoted text -

"Arvin Meyer [MVP]" wrote in message
...
"a a r o n . k e m p f @ g m a i l . c o m" wrote
in message
...

Just because you're not using the worlds most popular database
(SQL Server)

At last count, Access/JET had more users than all other databases
combined. While SQL-Server is definitely a great choice in many cases,
your statement is factually incorrect (as usual)
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com