AccessBlog.net

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

About Me Search
Alex
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

Labels:

Wednesday, July 13, 2011

Problems reported on Office 2010 SP1

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

Labels:

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

Labels: