If it's within a view - then you're looking for the...

Welcome to the team! It starts going down hill from here!!!!:P

unfortunately - that's a change that is slated to be introduced into some "Future version of SQL Server". As in - at some point, those will be REQUIRED as...

I don't disagree that we're no doubt dealing with different scenarios. I was merely pointing out there (as always) are many ways to skin the proverbial cat. I...

I'd look at implementing the good ole' crab trap technique. In short - operate with 2 structurally identical DB's. One is the one the users can enter into,...

Sounds more like different techniques than expectations. There are plenty of things to do to protect users from themselves, preventing the accidental edits, etc..., but without losing the bound...

Keep in mind that if you the Id you are outputting is an identity column, specifying an ORDER BY during the insert will give you a predictable order for the...

This should get you started.

http://msdn.microsoft.com/en-us/library/ms152543.aspx

(that's the 2008 version of the article - but the 2005 is a direct link at the top).

Also - might be worth taking a look under the Surface Area Configuration. Even with Express - the default setting is to NOT allow remote connections to your DB...

Off 2007 is worthless from my point of view. I have been using Access 2003 for the longest time.

I think the point is - I don't necessary want to...

All right - I'll be the fly in the ointment. I have to say - it's actually NOT the responsibility of the employees in the early stages of a...

I have to say - I don't agree with that at all. The point of even bothering to use Access, is that it actually uses BOUND controls. If...

The issue is that I am not sure what you're trying to go for. Could you mock up some data to show us what it is you're trying to...

Tracey - I'd actually look at an Access startup script to drop and re-add your linked tables based on which server is "up" at the time. There were several...

MAX is an aggregate.