Hmm, well that is a thought however the service desk people know nothing about fiddling around with tables.

What I might do (but not by Thursday) is to write a simple...

Woa there guys, you seem to be stampeding off in your own direction.

Yes, a questionable Management decision has left us at short notice without a DBA. As the only person...

Hi

Interesting point. However if I don't do the dba stuff it doesn't get done, and if anything goes "bang" then we're dead.

My company is the registering authority in the...

Thanks guys, some really useful stuff here.

Much as I absolutely love my job I don't think I'll be in the office this Sunday!

Krishna Potlakayala (5/7/2009)

---

Do you have any jobs...

Hi Guys

Sorry for the long delay in replying, but thanks a lot for all your help and the pointers, it's been very useful.

Cheers

Sam

Thanks guys this is really useful.

Some major restructuring is going on at my company, one of which is "...I've looked into it, taken advice and we don't need a full-time...

Yes this is common problem... had it loads of times.

It's related to changes in the SQL data, when Access can't work out what's going on.

A really common cause of...

Hi

Yep I'm also a VB-er but started life in Access... so yes you can capture keypress events.

Paul, just out of interest, can you explain why you need limit to 15 lines...

Bob

Just a thought.... if it isn't doing what you expect then if it does more than one thing in each "IF" "ELSE IF" or "ELSE" put a "BEGIN" and "END"...

Dave

Yep, a while ago we did some tests on a not-so-large table using EXISTS (and NOT EXISTS) against IN (and NOT IN).

EXISTS was way faster.... even with a table of only...

?

Rico said : " This is the first solution I've found out, but I'm looking for an alternative way to do it without writing all the columns name."

Why?

Sam

 

Rico said : " This is the first solution I've found out, but I'm looking for an alternative way to do it without writing all the columns name."

Why?

Sam

 

Hi

Just to expand on what Charles says, you cannot do anything like

SELECT * FROM @TableName .....

If you insist the way to do this is something like (..doing this...

Hi

Thanks for the replies and sorry for the delay in resonding...

Greg: I'm doing all sorts of things within the batches... database backups/executing SPs/running windows exe's. As I mentioned in my...