[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Can SQL Server Version 9 Create an Access 2007 table

Posted on 2009-07-14
2
Medium Priority
?
164 Views
Last Modified: 2012-05-07
I have a potential client who says they are using SQL Server version 9.  It is not clear to me what version 9 means.  Is this a flavor of SQL Server 2008?

At any rate.  I am wonding if this version of SQL is capable of doing a query and tranlating the result set into an Access 2007 table.  Y/N

0
Comment
Question by:WoodrowA
  • 2
2 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 24852382
SQL 90 = SQL 9 = SQL 2005
SQL 100= SQL 10 = SQL 2008
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24852407
>At any rate.  I am wonding if this version of SQL is capable of doing a query and tranlating the result set into an Access 2007 table.  Y/N

in order to populate the result t an MSAccess Table, u should create a linked server to the access database
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question