Access 2003 vs. 2002

[Bob S.]

I am trying to decide whether or not to upgrade to Access 2003 from
2002 but I'm having a difficult time weighing the options. Has anyone
already upgraded to Access 2003? Is there much difference between the
two versions or did Microsoft just apply a new GUI to 2002? I would
like to develop databases and applications with Access that are ready
to use as a web site backend. Is 2003 better suited to do this rather
than 2002?

Thanks!

[MacDermott]

As I understand it, there is no difference between the table format for 2003
vs 2002.
I would think that would be all you'd be using for a web site backend.

You should be aware, however, that Access is not often recommended for a
website backend because it doesn't scale well or easily support large
numbers of simultaneous "hits".

- Turtle

"Bob S." <rt*****@comcas t.net> wrote in message
news:2d******** *************** ***@posting.goo gle.com...

I am trying to decide whether or not to upgrade to Access 2003 from
2002 but I'm having a difficult time weighing the options. Has anyone
already upgraded to Access 2003? Is there much difference between the
two versions or did Microsoft just apply a new GUI to 2002? I would
like to develop databases and applications with Access that are ready
to use as a web site backend. Is 2003 better suited to do this rather
than 2002?

Thanks!

[Larry Linson]

The enhancements in Access 2003 were primarily for the corporate customer to
improve collaboration, XML exporting, and interoperabilit y with tools such
as SharePoint -- none of which seem pertinent to what you describe.

Access, strictly speaking, is the UI and development tool -- Jet is one
database engine, and Microsoft SQL Server Desktop Edition (MSDE) is the
other that comes with it. Either of the database engines is suitable for
low-traffic websites, but full Microsoft SQL Server or another server
database would be needed for a high-traffic website.

The Access UI and development tool can be used to organize the tables in
either database engine for use in a website, but cannot create a website
application. In this regard, it can be used to create "Data Access Pages"
but they are sufficiently limited (e.g., Internet Information Server
webserver and Internet Explorer browser only) that you see them, generally,
only on Intranets where the environment is closely controlled.

Larry Linson
Microsoft Access MVP

"Bob S." <rt*****@comcas t.net> wrote in message
news:2d******** *************** ***@posting.goo gle.com...

I am trying to decide whether or not to upgrade to Access 2003 from
2002 but I'm having a difficult time weighing the options. Has anyone
already upgraded to Access 2003? Is there much difference between the
two versions or did Microsoft just apply a new GUI to 2002? I would
like to develop databases and applications with Access that are ready
to use as a web site backend. Is 2003 better suited to do this rather
than 2002?

Thanks!

[Bob S.]

"MacDermott " <ma********@nos pam.com> wrote in message news:<yu******* ***********@new sread3.news.atl .earthlink.net> ...

As I understand it, there is no difference between the table format for 2003
vs 2002.
I would think that would be all you'd be using for a web site backend.

You should be aware, however, that Access is not often recommended for a
website backend because it doesn't scale well or easily support large
numbers of simultaneous "hits".

- Turtle

"Bob S." <rt*****@comcas t.net> wrote in message
news:2d******** *************** ***@posting.goo gle.com...

I am trying to decide whether or not to upgrade to Access 2003 from
2002 but I'm having a difficult time weighing the options. Has anyone
already upgraded to Access 2003? Is there much difference between the
two versions or did Microsoft just apply a new GUI to 2002? I would
like to develop databases and applications with Access that are ready
to use as a web site backend. Is 2003 better suited to do this rather
than 2002?

Thanks!

Thanks for the insight-I appreciate the help!

-Bob S.

[Bob S.]

"Larry Linson" <bo*****@localh ost.not> wrote in message news:<pF******* ***********@nwr ddc01.gnilink.n et>...

The enhancements in Access 2003 were primarily for the corporate customer to
improve collaboration, XML exporting, and interoperabilit y with tools such
as SharePoint -- none of which seem pertinent to what you describe.

Access, strictly speaking, is the UI and development tool -- Jet is one
database engine, and Microsoft SQL Server Desktop Edition (MSDE) is the
other that comes with it. Either of the database engines is suitable for
low-traffic websites, but full Microsoft SQL Server or another server
database would be needed for a high-traffic website.

The Access UI and development tool can be used to organize the tables in
either database engine for use in a website, but cannot create a website
application. In this regard, it can be used to create "Data Access Pages"
but they are sufficiently limited (e.g., Internet Information Server
webserver and Internet Explorer browser only) that you see them, generally,
only on Intranets where the environment is closely controlled.

Larry Linson
Microsoft Access MVP

"Bob S." <rt*****@comcas t.net> wrote in message
news:2d******** *************** ***@posting.goo gle.com...

I am trying to decide whether or not to upgrade to Access 2003 from
2002 but I'm having a difficult time weighing the options. Has anyone
already upgraded to Access 2003? Is there much difference between the
two versions or did Microsoft just apply a new GUI to 2002? I would
like to develop databases and applications with Access that are ready
to use as a web site backend. Is 2003 better suited to do this rather
than 2002?

Thanks!

Thanks a lot for the advice. Your detailed reponse was very helpful.

-Bob S.