Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danielqk
Starting Member
4 Posts |
 Posted - 2007-04-24 : 15:44:07
|
| How can I use MS acess to connect to SQL server 2000 and retrievedata in SQL server using SQL language? |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-04-24 : 16:22:27
|
| 3 Ways that I can think of, google and Access Help will give you lots of information:1. In your Access mdb file, create linked tables that link directly to MS SQL Server tables2. Create an MS Access ADP project, which links to an entire SQL Server database and serves as a "front end"3. In an MDB file, create pass through queries that execute SQL directly against a SQL Server database- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
|
|
|
Reporting service using MS acess