Yes, but as I said, this is something that needs to be coded in some asp page. Or any web language. You need to find tutorials to do...

What do you mean by Access???

You can interact with a db with an asp page (or .net C#/ASP.net). But the access work is done on the server, not in...

You mean something like this??

SELECT

c.name

, O.id

, case when I.indid BETWEEN 1 AND 254 AND (I.status & 2048 = 2048 or I.Status = 16402 /*clustered + unique*/ and...

Can you briefly explain what you're trying to achieve in this trigger.

Also do you expect this to work if you insert multiple rows at the same time??

Isnull(somecol, somevalue) will force the server to do a scan of an index, or worse, the table to fetch the rows. The 2nd where condition will permit a seek...

A couple of ideas :

For the small table. I'd put the index even if you don't expect the table to be big... you never know, in 10 years,...

Stupid question warning : Does the table exists (on that connection) when you try to create the view?

That code looks wrong to me.. Can you post the whole trigger code?

This is what Frank is talking about :

CREATE FUNCTION [dbo].[Split] (@vcDelimitedString nVarChar(4000),

@vcDelimiternVarChar(100) )

/**************************************************************************

DESCRIPTION: Accepts a delimited string and splits it at the specified

delimiter points. Returns the individual items...

On a last note.. you're no gonna get any performance from a query like this. Myabe you could use a compound index on those 3 columns and use this...

I just don't see why. This could return 1,2 or 3 rows each time. Much simple to always return one, then use another form to edit the other...

What's the question??

We had the same problem here. Just ask the users to copy the file to their computer from a shared drive (where you release the new versions). That...

Then in that case, maybe I'd do two forms to present the data, one for each table, since anyways, you can't always update a view with multiple tables, or when...

If by object you mean table, when losing the dependecies chain, that's simply because the server creates a new table, copies the data to it, recreate the indexes and constraints,...