It's the same as any other index, just with more columns. However, as Sergiy suggested, you might want to read up a little and better understand what you're going to...

If the problem is widespread, I don't see any great way to reorder them except by dropping and recreating.

However, if you don't have many indexes, why not just add...

Good for MSFT! Glad they have the domain.

I think we're sidetracked off my original aim. Not so much that we give them a better editor or OS, but maybe there's...

Very amusing from my Texas colleague above.

And good points made. However the poorest 90% is a spectrum of people. Some have food and electricity. Some have clean water. I'm amazed...

Can you post some sort of sample data that you'd want to see?

It's a security issue for the most part. Check logins and you might need to re-add the new groups (as new domains). IT might reach down into users, but I...

Scripting is the best bet, but you shouldn't use user permissions. Use roles.

As you script things out, create a role on the new server and give it permissions and then...

Will,

Not really digging through too hard, but this line caught my eye

OFF_COD between '0000' and '9999'

Are there other values? This seems like a strange join condition. Can it be <...

Jim brings up a good point, but the problem with Access is it makes it too easy for the secretary or very unknowledgable person to build something they can use...

There are definitely more important things than software, but that doesn't mean we shouldn't contribute in our area.

I tend to like the 1000 @ $700 model rather than the 1...

Michael,

Nicely put and you are welcome.

And more to come!!

XLS updated as well.

Not sure Sonasoft will help with bad disks. If the disks are bad, you need a recovery service for the disks.

If you can read the disks somewhat, call Microsoft....

I agree with Michael above. The code is the same. Licensing is an administrative thing.

Jez has a good point. I'd use full pathing when setting up the job, not relative pathing, to test it. If that works, you know where your issue is.