Buy a copy of access 2003?

[Donald Grove]

I do programming in Access 2000 and 2003. I don't have a copy of 2003
myself, though.

I have read about the adp software that comes with Access 2003, that
converts an application to an access front end with a SQL server
backend. It sounds like a good way for me to begin to learn about SQL
server.

I have thought about just shelling out the bucks for a copy of Access
2003, but the adp software is really the only reason. Do the folks
here think I should do it? Is Access 2003 the last version of Access
there is ever gong to be, or is there a higher version coming out
soon?

[Allen Browne]

There will be a new version of Access released early in the new year. You
can read up on what the actual Access developers at Microsoft are saying
about it here:
http://blogs.msdn.com/access/

ADPs are not a great idea, and are not well supported in Access 2007. They
are one way to learn about SQL Server. Another is SQL Server Express
http://www.microsoft.com/sql/edition...s/default.mspx

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Donald Grove" <do*********@ve rizon.netwrote in message
news:6u******** *************** *********@4ax.c om...

>I do programming in Access 2000 and 2003. I don't have a copy of 2003
myself, though.

I have read about the adp software that comes with Access 2003, that
converts an application to an access front end with a SQL server
backend. It sounds like a good way for me to begin to learn about SQL
server.

I have thought about just shelling out the bucks for a copy of Access
2003, but the adp software is really the only reason. Do the folks
here think I should do it? Is Access 2003 the last version of Access
there is ever gong to be, or is there a higher version coming out
soon?

[Albert D. Kallal]

"Donald Grove" <do*********@ve rizon.netwrote in message
news:6u******** *************** *********@4ax.c om...

>I do programming in Access 2000 and 2003. I don't have a copy of 2003
myself, though.

I have read about the adp software that comes with Access 2003, that
converts an application to an access front end with a SQL server
backend. It sounds like a good way for me to begin to learn about SQL
server.

There is not a special conversion included in a2003 that is really much
different then a2000. Access 2000 also included ADP's.

So, the inclusion of ADP's is not new to a2003. The data migration wizard
might be better, but this is a far cry from a system that converts a mdb to
a adp + sql server based appcation.

If you want to build a 100% sql server based ms-access application, then you
can do this in a2000, and simply create a database project. The same applies
to a2003. So, the ADP feature you ask about is part of a2000.....

>
I have thought about just shelling out the bucks for a copy of Access
2003, but the adp software is really the only reason. Do the folks
here think I should do it? Is Access 2003 the last version of Access
there is ever gong to be, or is there a higher version coming out
soon?

Office 2007, and ms-access 2007 is in beta right now. So, it really is a
question if you need a2003.

Actually, the current prices for ms-access 2003 are very affordable.

They are:
http://www.microsoft.com/office/acce...y/default.mspx

$229 for full version of access 2003
$109 for upgrade version
(qualifying versions for upgrade go back all the way to access97/office 97).

In fact, even the really cheap works database qualifies for a upgrade (the
last 5 pc's I purchased came with works!!!).

So, if you are like me, and have a self with 5 office 97 disks, between
works, and a97 disks laying around...you have
plenty of opportunity to purchase the upgrade version of access for just
over $100....

At that price...it really is a good deal, and I would not even worry about
future versions (but, future versions are in the pipe...).

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com

[david epsom dot com dot au]

There is a new stand alone version of the upgrade wizard.
I think that it is a free download. Like Access 2007, it
is another attempt to get serious developers to move to
SQL Server and the Net framework.

(david)

"Donald Grove" <do*********@ve rizon.netwrote in message
news:6u******** *************** *********@4ax.c om...

>I do programming in Access 2000 and 2003. I don't have a copy of 2003
myself, though.

I have read about the adp software that comes with Access 2003, that
converts an application to an access front end with a SQL server
backend. It sounds like a good way for me to begin to learn about SQL
server.

I have thought about just shelling out the bucks for a copy of Access
2003, but the adp software is really the only reason. Do the folks
here think I should do it? Is Access 2003 the last version of Access
there is ever gong to be, or is there a higher version coming out
soon?

[Tom Becker]

On Sun, 20 Aug 2006 12:10:45 +1000, "david epsom dot com dot au"
<david@epsomdot comdotauwrote:

>There is a new stand alone version of the upgrade wizard.
I think that it is a free download. Like Access 2007, it
is another attempt to get serious developers to move to
SQL Server and the Net framework.

Isn't .net for web pages? Should we be using something besides
access with SQL Server to make apps with forms and reports and all?
What is the best book to buy to learn what we are supposed to be
doing?

[david epsom dot com dot au]

ASP.Net is for web pages. VB.Net and C# (.Net) are for
Windows applications. dunno what we are supposed to
be doing, but if you can make a living at it you can't
ask for more.

(david)

"Tom Becker" <wl************ @hotmail.comwro te in message
news:pf******** *************** *********@4ax.c om...

On Sun, 20 Aug 2006 12:10:45 +1000, "david epsom dot com dot au"
<david@epsomdot comdotauwrote:

>>There is a new stand alone version of the upgrade wizard.
I think that it is a free download. Like Access 2007, it
is another attempt to get serious developers to move to
SQL Server and the Net framework.

Isn't .net for web pages? Should we be using something besides
access with SQL Server to make apps with forms and reports and all?
What is the best book to buy to learn what we are supposed to be
doing?

[Larry Linson]

"david epsom dot com dot au" wrote

ASP.Net is for web pages. VB.Net and C# (.Net) are for
Windows applications. dunno what we are supposed to
be doing, but if you can make a living at it you can't
ask for more.

VB.NET and C# are used to create web pages with ASP.NET, and, IMNSHO, for
"normal business database" applications, .NET is not nearly as good as
Access (nor as good as classic VB, for that matter).

I was in hopes that with the next (codename Orcas) release of Visual Studio,
..NET would begin to live up to its original promises of simple, easy, and
powerful Windows application development. However with the current Microsoft
emphasis on web applications, I may be disappointed yet again.

Larry Linson
Microsoft Access MVP