I think that your line with IDENT_INCR is actually the answer to the original post:

select (ident_current('MyTable') + IDENT_INCR('MyTable')) as NextID

That tells him the NEXT ident value, as desired.

For my part,...

Sushila, thanks for the info. I never ran across CHECKIDENT.

I did a quick run to test my theory of what it does. Of course it returns the value...

Phil's question is the right one: Once you have the 'next' identity number, what are you going to do with it?

Typically, use IDENT columns when you want a blind,...

A word of followup on the username solution:  Expect the MDB or MDE that contains the work table to bulk up.  It's not a problem, just the cost of doing...

In SQL Server proper:  Either create a new category of object called a Query, where we can store SQL that is capable of returning an ordered result set, or add...

Damn I wish I had written this!  The point (don't combine dissimilar data, even "lookup" data, into one table) is absolutely correct.  The presentation looked just fine.  Derivation of the...

If you're using Make Table to gather your report data, your only solution is to be sure that each user has a copy of the front end and that the...

I'm sorry that I'm so very short of time right now.  I wanted to say more, but here's the core:

You want DateDiff().  You specify how you want the difference in...

>>I need to take away [startdate] - [enddate] but I need to get the month and display this in a query in Access.

I'm Curious to know what your itention is. ...

To extend Carolyn's suggestion a bit:  If you are using permissions in SQL Server fully (and you know that you should!), remove delete permissions from all tables and provide stored...

Unless you have a really good reason for letting users do manual table-linking, you would do well to control it in one of several ways:

You link all the tables yourself,...

Well, thanks again for even more useful information.  I just got our "convert the queries to view" project under way in prepartion for moving to an ADP, and here's the...

The one thing that has kept us in our MDB is the large inventory of Access queries we call on.  For many applications, you start with Access because it is...

Thanks for the details!  Gratefully received.

The sad part is that we're not just missing something obvious.  I could handle that little embarrassment.  Lots of practice.

It really isn't quite round, is...

Thanks for letting me know the outcome.

I have a question for you, on your success with digital signatures.

We have a certificate.  We signed our application.  We put it on the...