473,390 Members | 1,272 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,390 software developers and data experts.

Buy a copy of access 2003?

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

Similar topics

0
by: Casey | last post by:
Is there a way to copy only the changed files of a web application when doing an "Only files needed to run this application" copy, using VS.NET 2003. Visual Interdev 6.0 had the option to "Copy...
6
by: Shyguy | last post by:
I want to create two buttons on a form. One would allow the user to Copy the contents of the current records memo field, the other would allow them to print. I set up a report based on the memo...
1
by: Steve | last post by:
Does anyone know a way to copy and paste or similar a list of fields in an Excel worksheet into Access to create a table? Example, Sheet1 has this list in A1 to A7: CustomerID FirstName LastName...
2
by: HB2 | last post by:
I use to be able to highlight several records in a table, copy them and paste new records. Now when I right click the records the copy and paste functions are disabled. How do I enable them? ...
1
by: gale | last post by:
I have an Access 2003 project. I need for users to be able to run a report and copy the report in Excel format to a web server. The problem is, they do not have write access to the web server. I...
11
by: Danny J. Lesandrini | last post by:
Has anyone else noticed this? I searched group archives and found nothing, but it's really starting to irritate me big time. Here's the steps to reproduce the problem: Copy something to the...
2
by: camp | last post by:
I use VS.Net 2003 on Win XP Pro SP2. I created an ASP.Net app on local IIS. Now I just wanted to "Copy Project" to remote server, but I get this error: "An error occured while copying the...
8
by: Jerome Ranch | last post by:
Okay So I've got pivot tables setup in Access 2003. Only about 30K records in the current 2005 databases...the pivots summarize the info in a number of nice ways. I need to get the pivot tables...
5
by: Bugran | last post by:
I am trying to copy a textbox field on a form (which basically contains the body of a letter) into a memo field in a table (Access 2003) for later printing later. Of course Access queries/SQL will...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

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.