Is it possible to run SQL Server 7.0 views from within MS Access?

[Rahel]

Is it possible to run SQL Server 7.0 views from within MS Access?

 

[calahans]

Rahel<br>
<br>
Sorry, I don't have a copy of SS at the moment - it would <br>
be easy to test it out!!<br>
<br>
C

 

[DarkMan]

It's definitely possible... Not sure about Access 2000, but in Access 97, just get the Upsizing Tools at <A HREF="

http://www.microsoft.com/accessdev/a-free.htm"

TARGET="_new">

http://www.microsoft.com/accessdev/a-free.htm</A>

and install them. Once installed, you can either open any database or start a new one. <br>
<br>
From the Tools menu, go to Add-Ins, then SQL Server Browser. Choose the ODBC datasource for your SQL database (or make one), enter your username and password, and you'll have an Access like window open up where you can view your tables, views, default settings, rules, and stored procedures.... You can also join these remote tables into the access database you have open for direct access and you can run ad-hoc sql on any of the tables. Makes a pretty good front end for SQL Server...<br>
<br>
Let me know if you have any trouble getting this to work... <p>Doug Trocino<br><a href=mailto:dtrocino@tecumsehgroup.com>dtrocino@tecumsehgroup.com</a><br><a href=

http://www.tek-tips.com>Tek-Tips

Forums</a><br>Technical Director<br>
Tecumseh Group, Inc.<br>
Sponsors of Tek-Tips Forums<br>

 

[Husein]

In Access 2000 create Access Project and you will have both Views and Stored Procedures. Office 2000 comes with a cutdown version of SQL Server 7.0 and you use Access as an Enterprise Manager