Managing Data Remotely on a SQL Server

[Kfalbrec]

I am helping my brother put together a new business PC. We will b
upgrading his MS Office Suite and would like to install Office XP 200
rather than 2003 due to a lower price.

He is currently using Access 2000 and says he is limited when it come
to managing SQL data on a server. What capabilities does Access 200
offer over Access 2000 as far as managing data remotely on a MS SQ
server? And, are there additional SQL server features in Access 200
that would make the added expense worthwhile

 

[Douglas J. Steele]

What exactly does he feel are the limitations Access 2000 has with respect
to managing data on a SQL Server server? Access 2000 should be fine for
virtually all normal tasks.

Without knowing what he feels is missing, it's difficult to say where Access
2002 provides any additional capabilities.

 

[Albert D. Kallal]

There are some updates to ms-access in a2002. However, both a2000, and a2002
can be used to work directly with sql server.

In fact, the last 3 versions of office (a2000, a2002, a2003) have all
included a free version of sql server on the office cd. The price to use sql
server is thus quite low!

All of the above versions thus can be used to manage, and create, and use
sql server. You can even use stored procedures.

I think a bit more explanation here needs to be given as to what is meant by
the term:

He is currently using Access 2000 and says he is limited when it comes
to managing SQL data on a server.

Hum, I can't say it is a problem. On the other hand, often, instead of using
a ADP project (that is a ms-access project specifically designed to work
with and manage sql server data tables), you can use linked tables and ODBC.
However, if you are using odbc, then you can' use the sql server management
tools included in ms-access. On the other hand, if you are using odbc to sql
server, then likely you have, use, and know the enterprise tools that ship
with sql server anyway. So, you have both adp projects in ms-access, and if
you don't want to use ms-access to manage sql server, then there is always
the standard sql tools (EM) that are available. You can even use both!

Either way, both tools allow remote management of sql server...so, unless
more details are given, the above "he is limited" is not enough info.

 

[Kfalbrec]

Thank you for the responses, I'll pass the information on