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 |
|
ggarza75
Yak Posting Veteran
50 Posts |
 Posted - 2009-07-31 : 17:28:31
|
| In Access 2003, when you click on File-->Connections, you'll get the Data Link Properties window. This window allows you to point Access to a SQL server.I'm been look all over this same window in Access 2007. Does anyone know where this is located in Access 2007?Thanks. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-31 : 21:29:44
|
click "External Data" on the menu bar, then MORE, then ODBC  |
 |
|
|
ggarza75
Yak Posting Veteran
50 Posts |
Posted - 2009-08-03 : 10:44:40
|
quote:
Originally posted by russell
click "External Data" on the menu bar, then MORE, then ODBC
I thought of the same thing, but this does not help me though. Thanks though.This is what I'm trying to accomplish.I have a Access 2003 file that accesses our SQL 2000 server. I'm trying to upgrade this Access file to Access 2007. All the other objects with in A2003 imported just fine to A2007 accept for the query objects, which are stored procedures and views. Now these Query objects reside on the server, which I'm trying to have Access 2007 view. This is where I'm having the issue. How can I get my new A2K7 view these Query objects that are on the SQL side?Thanks for any help. |
|
|
|
ggarza75
Yak Posting Veteran
50 Posts |
Posted - 2009-08-03 : 11:22:47
|
| I FINALLY GOT IT!!!If anyone has this issue, here's the solution. When creating a new database, save it as a .adp. Once saved, a window prompt will appear and ask you which server you want to connect to. After you entered the settings, you are set. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-03 : 11:33:35
|
| Views show up in the list of tables. The way I showed above is how to access MS SQL Server. You'll be prompted to pick or create a data source.To execute stored procedures, use a pass through query. See this link: http://office.microsoft.com/en-us/access/HA102064881033.aspx |
|
|
|
|
|
|
|
|
Data Link Properties