I am looking for suggestions for utilizing MS Access Cross-Tab capabilities
via MS SQL 6.5 can you please help me?
Here is some additional background related to my project where this
capability will be needed:
I am currently in development of a client/server internet application using
ASP, IIS, MS SQL 6.5 and Visual Interdev. This application successfully
collects and stores data via Active Server Pages (ASP web pages) into MS SQL
6.5 tables. Additionally, qualified internet users have access to query
these tables. One such query is an ad-hoc cross-tabulation query. This
ad-hoc cross-tabulation query has been successfully designed within MS
Access 97 utilizing MS SQL 6.5 tables via ODBC. Also I have simulated this
ad-hoc query outside of MS ACCESS by using a combination of ASP + VBScript
and MS SQL 6.5 procedures. My present concerns and challenges are listed
below in the form of Questions to which I am seeking your help to answer.
Q1) Is it practical (performance wise) to employ MS ACCESS 97 via ASP
VBScript to perform this ad-hoc? And if so then do you have any MS ACCESS
Q2) Can MS ACCESS queries be executed from within a MS SQL 6.5 procedure?
And if so how?
Please forgive any questions that may seem obviously elementry or to vague.
Thank you in advance for your time and help.