I hate the 'getting there/getting home' part of travel. It's time consuming and uncomfortable.

But, once at the location I'm fine. My company has an office in Cambrige and I really...

Hi Steve -

I believe that usability is massively important. Companies that spend time making products 'discoverable' benefit by reducing the load on their support staffs and documentation teams.

From a customer...

Damon -

Off topic a bit. Is it possible to create a linked server in the express version?

Joy

I don't use SQL Xpress -it's too limited...

Hello,

Yes I did figure out how to create a linked server to an Access 2007 database in SQL Server 2005.

First, be sure to install SP2 of SQL Server 2005...

Actually I just did this yesterday, however, it was on SQL Server 2005 Standard edition. Not sure it applies to Express.

I opened SQL Server Management Studio, created a new query...

I have tried that... what I need to know is if anyone has made it work and what setting they used.

That won't work... the file extension is no longer .mdb - in Access 2007 it is now .accb - also the provider type has changed. You can no longer use...

Actually it is an Access 2007 database. I do not want to import the tables. Rather, I would like to create a linked server.

This would allow me to query the...

Assuming you are using SQL Server 2005 - did you download SP2? It's my understanding that SP2 is required...