I wound up fixing the problem by defining a custom function:

CREATE FUNCTION NoNullsBit(@input bit)

RETURNS bit

AS

BEGIN

DECLARE @result bit

if @input is null

set @result = 0

else

set @result = @input

RETURN @result

END

I then modified my...

Well you're absolutely right. It is because of nulls in the bit fields. The weird thing is though, that I knew about that problem, and I'd previously set...

Hi Matt,

Thanks for responding. It's a regular Access file, an MDB. All the tables are brought over via ODBC link tables, and are bound to the forms, so...

I totally agree with you. In an ideal world I'd re-write the application logic. Unfortunately, I'm just cleaning up after the application developer, and there isn't the budget...

SQL 2005 has the ability to run SQL 2000 DTS packages. You can even download and install a tool to allow you to edit the DTS packages within SQL...

Oh, you're right. Looks like it has. So what's the deal? What am I supposed to do here? Should I just re-create everything directly in SSIS?

Aaron

No, I was wrong. It was, in fact, that SSIS wasn't installed. I installed it and now I get a different error:

Executed as user: WWDB\SYSTEM. Microsoft (R) SQL...

Thanks John,

That did it. It was a SQL Server Integration Services job step type.

Now of course I'm getting a new error. This transition to 2005 has...

It helps a lot.  Thank you.

Aaron

And I take it they're both on this forum?

Thanks for your help, Mike.

Aaron

Does FTS index files (Word, PDF etc.) on the harddrive or just within SQL Server as Binary data types? 

Aaron

We don't have the server yet.  It's still in the planning stages.  I have other servers I could get ther version info for, but no point. 

It will probably be...

Wow.  Cool. I had no idea about the iFilters.  That's amazing.

How does FTS deal with phrase searches?  Does it index longer phrases, to speed up searches for, say "Four Score...

Hi Remi,

I posted it on Access Monster.  So far no responses.  I guess no one knows a solution to this issue.  Perhaps there is none.  It's just Access 2000 blew...

Is my question clearly presented? 

Just to summarize even further:

Access 2000 Combo boxes don't seem to be searchable, if the value stored in it is an ID number instead of...