I don't see any reason not to upgrade both to 2005 versisons.  The Analysis Service is included with SQL Server 2005 Standard and Enterprise, so there is no additional cost...

Also, Access Date/Time can handle a larger range of dates than SQL.  In the past I've found typos can cause problems like this, e.g. 01/03/101 is valid in Access...

Is JDBC is like ODBC then an extra operation can cause incorrect values to be posted back to the client as each operation returns its own recordset, even empty ones containing...

Have you experimented with SET NOCOUNT ON in the trigger?  I haven't worked with JDBC, so I'm not sure what the impact would be.

Firstly the constraint that you are building would not "allow zero lengths", but would "only allow zero lengths", that is all fields would have to be empty strings.

I think...

This should cause no problems, you can either get SQL to implicitly convert, e.g.

INSERT INTO #mytable
VALUES (myguid)
SELECT mytextguid 
FROM #mytexttable

or explicitly convert yourself, e.g.

INSERT INTO #mytable
VALUES (myguid)
SELECT CAST(mytextguid AS uniqueidentifier)
FROM...

A GUID is 16 bytes, which when displayed as a varchar is displayed as 36 characters of text.  Using hexadecimal notation each byte is represented by 2 characters. This would...

It is possible - two was spring to mind, using creating and OLE instance of the Excel object using sp_OACreate, etc., which is messy and heavy going or by linking to the...

Unfortunately Windows Server 2003 does not support SQL Server 7.0!  You will have to upgrade to SQL Server 2000 Service Pack 3. 

I had an...

If you restore a backup of your existing database to the new database that you wish to replicate, you can add a row guid to you existing column (assuming that the datatype...

Are you using ADO or DAO?

If you are using ADO try converting the SP call into a command object.  You can then use a Return Value parameter to pick up...

Lital,

Take a look at http://www.sqldts.com/ to see some of the good things that you can do with a DTS job.  You may be able to find something of use. 

From...

Lital,

What are you trying to do in terms of final results?  What updates do you wish to make to the Access tables? 

For example are you trying to log the...

Typically in Access I'd fire trigger like code using the Form object's Before Update and/or After Update events.

Another option would be to move your database updates into a VBA function, and...

Because Access's VBA communicates to Access's data using ADO.  You can use this from a VB Script too.  Or better still, you can use a DTS dataconnection and add a...