
Query Against Access DB over the Web
You can treat a pre-defined Select Query in Access as essentially equivalent
to a SQL Server View for this purpose. Just create a query with all of the
joins and save it, then construct your SQL statement in ASP using the query
name.
I think the 255 character limit (it sticks in my mind too) is only related
to the WHERE clause, not to the complete SQL statement. If there is a limit
on the overall size of the query, it's much larger than that.
HTH,
Glenn
Quote:
>Some of the queries are rather complex and involve joins on several tables.
>The resulting SQL statement is rather long and tedious to contsruct. If
>this were SQL Server I could create a view and query off of it. However, I
>don't know how I can do something comparable in Access.
>Does anyone have any ideas on how to approach this?
>Also, Does Access/JET have a limit on the size of the string that can be
>submitted as a SQL statement? For some reason 255 characters sticks in my
>mind.
>Thanks,
>Dave