I'm running SQL Server 2005 Express.
I attached an Access mdb.
It shows it to me under linked servers.
When I do a simple Select * From AccessServer...Tbl I get a message Executing Query but nothing happends. The table is only 25 rows and this went on for an hour before finaly cancelling. And when I pressed Cancel Executing Query it went on for a while until I finaly shut down server management.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.