News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Thursday, July 21, 2011

Workaround for Access 2010 SP1 crash

How fix Access crash after installing SP1: Acc2010: You receive an error in Microsoft Access using the built-in wizards after installing Microsoft Office 2010 SP1


Wednesday, July 13, 2011

Problems reported on Office 2010 SP1

Office 2010 SP1 and Access 2010 Runtime SP1 are broken Cypris' lookout


Tuesday, July 05, 2011

Limitations of SQL Azure: only one DB per connection

If you don’t know yet – Access can work with SQL Azure database, like it works with SQL database, you can link tables and run pass-through queries.Works great! I did some work recently on porting SQL server app to SQL Azure, and found that you can’t use following syntax:
Select [SupplierID] From [AlexDB]..Suppliers
It fails with "reference to database and/or server name in is not supported in this version of sql server" error.
Fellow MVP pointed me to SQL Azure and relational data : Limitations of SQL Azure article, which explains why it fails: its nature is similar to USE restriction – you can use one connection with only one SQL Azure database.

Labels: , ,

Friday, July 01, 2011

SQL Server Development Techniques and Scripts

Just found few interesting samples here: SQL Server Development Techniques and Scripts - a great resource of Transact-SQL scripts and other SQL Server code and techniques