Just a thought.

There is a limit to the number of characters that can be stored in an Excel cell.  I think it is 32768.  Could this be your problem?

In the April 2006, ADVISOR GUIDE to Microsoft Access, there is an article by technical editor Andy Baron titled, "Linked Excel Data No Longer Updatable."  In this article he explains...

That is correct.

FYI

The reason for separate copies is that after the first user opens an ADP, subsequent users opening the same, exact ADP will open it Read-only.  If any of...

There are two ways to use MS Access with SQL Server:

1. With an Access Project (.adp) connecting directly to SQL Server.

2. Or, with an Access Database (.mdb) using ODBC.

The project...

If you use an Access Project (.apd), all the user tables and views will available, but the system tables and views will not.

You also spelled "DISTINCT" wrong in your example:

select distince p.id, p.comment, t.qty, t.amount, pr.name, t.time

You did not include enough information for an actual solution to be presented. However, the following example shows you how to conditionally SUM a column's value, using a CASE statement:

SELECT...

You may can use ADO to insert into the log and bypass the transaction:

1. Use sp_OACreate 'ADODB.Connection' to create a connection.

2. The use sp_OAMethod to "Execute" your SQL Insert Command.

xSQL Software has two products sold separately or as a bundle: A database object compare tool (xSQL Object), and a data compare tool (xSQL Data Compare).  Both work very well.  With the...

SELECT MONTH([dateadded]) AS MonthOfYear

  , DAY([dateadded]) as DayOfMonth

  , datepart(hour, [dateadded]) as HourOfDay

  , SUM(CASE WHEN YEAR([dateadded])='2005' THEN 1 ELSE 0 END) as Count2005

  , SUM(CASE WHEN YEAR([dateadded])='2006' THEN 1...

SELECT MONTH([dateadded]) AS MonthOfYear

  , DAY([dateadded]) as DayOfMonth

  , datepart(hour, [dateadded]) as HourOfDay

  , SUM(CASE WHEN YEAR([dateadded])='2005' THEN 1 ELSE 0 END) as Count2005

  , SUM(CASE WHEN YEAR([dateadded])='2006' THEN 1...

/*

This may or may not execute without modifications.  I did not have any data to test it, but it is an example of one way to solve your problem:

  Create...

Your problem has nothing to do with Enterprise Manager.  No matter how you add a column to a table, a previously created view will not handle the table as you are...

Scott,

What Cory added to your stored procedure was the @year input parameter.  This input paramter is needed as part of the stored procedure if you are wanting to pass...