For those who like that type of stuff, there is an excelent video on YouTube: "Supersymmetry, Extra Dimensions and the Origin of Mass", which covers a lecture on how they...

I missed PASS 2010, but would like to read any editorial or published material, if available.

once you done the uspsizing, you should backup and remove MS Access tables and leave in only their SQL Server equivalents. Than everything that fails you'll fix bug by bug....

My Access is a bit rusty, but is it possible to 'catch' that error and than do whatever you want with it?

Another way is to only use stored procedures on the SQL Server side. That way MS Access can not 'see' any tables. And one can put any security he wants...

You have a problem with the way referential integrity between the two tables is organized. If you have one-to-one relationship than you'll by deleting one raw in table A, you'll...

Another, nearly perfect way, to connect to the remote SQL Server is through Microsoft Access. You have drivers and everything that is necessary included in Access, and you can simply...

OK, and how do you include "unknown unknowns" into your model. That was the first question, second question would be, what about inovation, like new product or new service, with...

Databases are scary. Just imagine how much Google knows about you and your interests. And they admit themselves that they are logging everyghing, every keyword you typed in and every...

Grasshopper is right, when talking about importing data from long ASCII files main request is disambiguation. So you must make sure that caracter that is used as delimeter is not...

You can as well create databases / schemas for themselves and than change ownership to their logins. You can do it in any order you want, database first, or ligins...