Answer to question 2) about 3rd party program: there probably is, but I
am not aware of any.
Answer to question 1) if you are using an Access Data project (ADP),
then yes because Access is acting as a front end to the Sql Server. So
everything you would see in the Access database windows (tables, queries
only) would be the stuff in your sql server DB.
But if you are using an MDB, then you could use ADODB to invoke a stored
procedure on the sql server.
Note: there are mixed feelings about ADODB and Access. The reason is
because people don't seem to be aware that even though you can use ADODB
within Access to query mdb tables -- ADODB is/was really desiged for
interfacing between Sql Server and Access at the com level (as opposed
to the .Net level). DAO is the data programming model that is native to
Access and thus, functions the most efficiently within Access. But DAO
cannot invoke a stored procedure that resides on a sql server. For this
you need ADODB.
With the proper permisions on the server, you can create an entire sql
Server DB directly from Access using ADODB. The cool thing about ADODB
is that it supports all of TSql and all of Jet Sql. But I wouldn't
bother using ADODB with Jet sql - it's over kill.
*** Sent via Developersdex http://www.yqcomputer.com/