Access 2003 and SQL Server 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harold Shapiro - 30 Jan 2008 15:33 GMT

I have a client who is having trouble modifying a SQL Server 2005 database
from Access 2003. I think they are trying to change not only data, but the
DB fields as well (tables, etc.)

Reply to this Message

Andrew J. Kelly - 30 Jan 2008 16:18 GMT

Access 2003 knows nothing of SQL Server 2005 and is not a proper tool to try
and change DDL. Why would they even think of doing that? Do they not have
SSMS?

Signature

Andrew J. Kelly SQL MVP
Solid Quality Mentors

>I have a client who is having trouble modifying a SQL Server 2005 database
> from Access 2003. I think they are trying to change not only data, but
> the
> DB fields as well (tables, etc.)

Reply to this Message

Spam Catcher - 30 Jan 2008 16:31 GMT

=?Utf-8?B?SGFyb2xkIFNoYXBpcm8=?=
<HaroldShapiro@discussions.microsoft.com> wrote in
news:D5B22100-B390-4714-B4C9-A9ADBC483FF2@microsoft.com:

> I have a client who is having trouble modifying a SQL Server 2005
> database from Access 2003. I think they are trying to change not only
> data, but the DB fields as well (tables, etc.)

Get them to use SQL Server Management Studio Express. It's a free tool to
management SQL Server.

Signature

spamhoneypot@rogers.com (Do not e-mail)

Reply to this Message