Viewing 11 posts - 1 through 11 (of 11 total)
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...
January 4, 2011 at 4:27 am
I missed PASS 2010, but would like to read any editorial or published material, if available.
January 4, 2011 at 3:58 am
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....
January 1, 2011 at 12:08 pm
My Access is a bit rusty, but is it possible to 'catch' that error and than do whatever you want with it?
January 1, 2011 at 12:03 pm
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...
January 1, 2011 at 12:00 pm
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...
January 1, 2011 at 11:43 am
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...
January 1, 2011 at 11:33 am
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...
December 30, 2010 at 9:13 am
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...
December 30, 2010 at 9:07 am
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...
December 30, 2010 at 8:42 am
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...
December 30, 2010 at 8:35 am