Thanks for that reminder, Bill Holt. I've seen that before but had completely forgotten about it and would have fallen for it again. I'm adding that to my "Access folder".

Are there any triggers on the SQL table? That could be part of the problem.

NOTE: You might have noticed a discrepancy in the database names. The actual database name is "DSM_CPKFinishing_be". I shortened it to "CPK" in our discussions, but have always typed the...

Yes, it's possible the service packs versions are different. I'll have to figure out what SP we had before.

"create database cpk on primary (filename='c:\mssql\data\cpk_data.mdf') for attach" didn't work either. I...

I tried:

EXEC sp_attach_db @dbname = N'cpk',

@filename1 = N'c:\MSSQL\Data\cpk_data.mdf',

@filename2=N'c:\MSSQL\Data\cpk_log.ldf'

I also tried it without the log file. Both times, I got the error.

Yes, I am. Another problem is that the we never did a "detach". We just stopped the services and copied the MDF and LDF file.