I edited my post to sound less grouchy but I still don't think Vista and Office 2007 have any advantages over their predecessors for developers and DBA's, unless they're writing...

If you can afford the Visual Studio Team System it has a feature that lets you take a subset of the data.

I am lucky at my current position, we hit 9.5 out of 10.

The only partial exception is #3 because Vista "presents no compelling reason for us to upgrade", Office 2007...

On Jan 2 at 6:30 AM MST using IE6 all I get is this

The page cannot be displayed

The page you are looking for is currently unavailable. The Web...

On a high level, I consider the stored procedure to be what in electronics is called a black box - you define the inputs and the expected outputs.

All of the...

Here's what you might do.

Take a backup from production and restore it as a TEST database. Then run Profiler on the production db and save the trace to a new...

Do you have any Memo fields in your tables? If you do, can you get to the tables and look for #Error in one of those fields. Compact & Repair...

You should have the form frmReports1 open, with valid entries, when you run the...

Here is some documenter code that I wrote about 10 years ago.

http://www.wvmitchell.com/blogger/billdoc_2k.zip

It has one module, three reports and a macro. You would import everything into your mdb and then run...

rbarryyoung (10/25/2008)

Yes, this is very easy to do with SSMS and this is how you do it with SSMS. However, despite appearances, that is not what SSMS actually does....

I'm not in favor of changing the order of columns, but it is possible.

It is very easy to change the order of the columns in SSMS if you go into...

In most cases you can disregard that message, but you will always be wondering if there is a bug in your code. Also, if you happen to be using MSSQL...

wayne.taylor (10/13/2008)

---

Hi All

I've got an Access 2003 database that I've upsized to SQL 2005 using an ADP application.

I've got a block on code as below:

Dim rstt...

The original article Q198755 does state that if you have the mdb open and also run the utility, it will show your machine twice in the list. The "updated" article...

Here is an easy way to to it. I've used this with Access 2000-2002-2003 and Windows 2000-XP-Vista. Edit the INI file to point to your database, and then just run...