I sent a message to Steve. He'll take care of this for you.

What are those pink calls?

This is a little more sofisticated than the normal student questions we get (like how do...

Where did he talk about access 2007?

Humility or humiliation ? :hehe:.

I don't know about the best way to do this. Personally, I usually setup a connection directly to the server in the access code, then run my queries that...

This is pretty much the best reason to use it... multiple servers/dbs/tables/columns admin tasks. While it's not good for everything, it sure has its uses in that area.

Now that's the most brutally honest topic title I've ever seen.

You should get a price for that :).

You must concatenate the control form into the query itself.

One step better would be to use stored procs.

Can you post the code that calls sql server? We'll be able...

Now I would like to hear that phone call... can you record it and post it here?? :w00t:

This is still important for the next DBAs who will need this thread.

This is what makes the difference between a good site and a great community.

Pay for itself Steve... I think it went a little beyond that!!!!!!! :w00t::w00t:

BTW, when is the next hitfix release??? (, *SSC rocks*. )

Congrats again on the half million. What has it done for me???

Let's just say that I wouldn't know anything in sql server if it were not for this site....

I'm still part of the audiance, and I think we should get another recall :).

As Steve said, use the datetime or whatever is usefull to recognize that file from a human standpoint, then use identity to insure uniqueness. Sometimes there are very simple...