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 |
|
pgill
Starting Member
17 Posts |
 Posted - 2007-08-13 : 15:07:46
|
| I have a MS Access user/developer that needs to pull data from SQL Server 2005 into his tables in MS Access 97, how can I make the data in SQL Server available to him without upsizing his MS Access databases? Thanks in advance. |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-13 : 15:15:03
|
| create one ODBC to connect to your sql server 2005 database.now in Access select Tables object from the left pane. now click newand select link table and click ok.now Select File Type as OBDC and click on Machine Data Source and select the ODBC for that database you created above.CLick ok and you will see the list of the tables. Select the required tables and check save password and click ok.You will see the link tables with the icon of a globe in the Acess Database. Make sure your user has the proper rights and cannot change the data in sql server if not authorized. so you should create the ODBC with that USER ID on his local machineAshley Rhodes |
 |
|
|
pgill
Starting Member
17 Posts |
Posted - 2007-08-13 : 15:51:12
|
| Ashley - Thank for your quick response, I'll give it a try. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-08-13 : 23:09:06
|
| You may also consider moving to using ACCESS ADP's which still have forms and reports and code but use SQL Server as the back end and then you can take advantage of Stored Procs, User Defined Functions, Views and all queries will be processed on the backend for better performance instead of pulling data across the network to perform joins between access data and sql data. |
|
|
|
|
|
|
Pull data from SQL Server to Access