Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time. September 2013 Entries
generic error in access 2013
Today I got an error in Access 2013 saying "Cannot open database ''.  It maybe not be a database that your application recognizes, or the file may be corrupt."

After doing some digging I figured out that Access 2013 has a database limit of around 2 GB, so when I was trying to import data that would push me past that limit, instead of giving me a useful error it gave me the message above.  Thank you Microsoft.

Posted On Friday, September 27, 2013 11:03 AM

generating complete insert statements for sql server table data
Ever have to create insert statements for a SQL Server table but can't figure out how to do so without hitting a character limit?  The only way I found (with rows that are over 50,000 characters) was to use sqlcmd with the -y parameter set to 0.

Posted On Tuesday, September 17, 2013 4:54 AM

Copyright © Alex Bransky | Powered by: