If I understand this correctly, you're looking for all the rows where the model is available in each listed color.

Maybe something like this:

select * from myTable a

where exists

  (

  select...

You can grant permissions to 'public'.  This has the effect of letting everyone who has access to the database (via sp_grantdbaccess or GRANT statement) inherit that permission.  Very useful for...

We ran across something similar, but it had to do with the volatility of the data in the database causing the statistics to get out-of-date.  We simply ran sp_updatestats periodically...

Or, try the following syntax:

Forms!Proposals.Controls!fkClientID.Value = NewClientLocationID

in the popped-up form.

We actually have the same thing going on.  It turns out that when you get to a certain number of characters (8192) then CRLF is included in the query output. ...

You may also wish use the EM GUI to check and see if SELECT permissions have been granted to 'public' for all tables in the database.  If they have, then...

We did the same as ccc24 with no changes.  Did someone remove BUILTIN\Administrators, maybe?

I have actually run across this in a production environment.  WinZip does not have a command line interface.  They have a separate product (for a small fee, of course) called...

Save the DTS package under a new name, delete the old one, and see if anybody complains.  If there is someone running it manually with DTSRUNUI on the command line,...