Don't forget that you need the SQL Native Client installed in order for Access to ODBC into Sql 2005. The old SQL Server provider won't work.

I agree that "you shouldn't even bother trying to pass this exam if you lack SQL Server 2005 experience". I've worked with SQL Server since 6.5, but 2005 has plenty...

I'm also using the Exam Cram for 70-431. I started with the Sybex book but there are many typos.

AFAIK the only thing you need is to install the "SQL Native Client" so Access can talk to SQL 2005.

Personally I use DAO within Access because you can manipulate schema, data, and Access objects within the same environment. I may use linked tables or pass-thru queries, depending on whether...

You cannot normally copy / paste an MDF if SQL Server is running, so, since your server is not running then copy / paste should work just fine.

Here is a password cracker for SQL Server:

http://www.ngssoftware.com/products/database-security/ngs-sqlcrack.php

It is possible to install IIS on XP Home, if you have a CD for Win 2000. You copy certain files from the i386 folder and adjust some config settings. I...

Solved my own problem. The shortcut in the Startup group needs a command-line switch:

"C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n

and the icon file is

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\sqlmangr.rll

In Sql Server 2005 your can turn on trace flag 1807.

Be aware that Columns_Updated() does not indicate what is different only what was touched by the Sql statement.

What about the VS Express version? Haven't tried it myself.

You get a minimal version of VS 2005 with SQL Server 2005 Developer Edition, this is all you get. There aren't any C#, VB or C++ options. . .

Microsoft Visual...

As a consultant, I get to see inside many companies & how they handle Net access. A few of them don't allow ANY access, period. Quite a few other companies...

I didn't realize you had that many db's, lucky you 😉

How are your backups set up now?