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

Buy a copy of access 2003?

P: n/a
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?
Aug 18 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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*********@verizon.netwrote in message
news:6u********************************@4ax.com...
>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?

Aug 18 '06 #2

P: n/a
"Donald Grove" <do*********@verizon.netwrote in message
news:6u********************************@4ax.com...
>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

Aug 18 '06 #3

P: n/a
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*********@verizon.netwrote in message
news:6u********************************@4ax.com...
>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?

Aug 20 '06 #4

P: n/a
On Sun, 20 Aug 2006 12:10:45 +1000, "david epsom dot com dot au"
<david@epsomdotcomdotauwrote:
>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?
Aug 20 '06 #5

P: n/a
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.comwrote in message
news:pf********************************@4ax.com...
On Sun, 20 Aug 2006 12:10:45 +1000, "david epsom dot com dot au"
<david@epsomdotcomdotauwrote:
>>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?

Aug 21 '06 #6

P: n/a
"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

Aug 21 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.