I know in SQL Server you can create temp tables. No such option in
SharePoint?
I appreciate the suggestion. Unfortunately, not doable in this case. My
client (for whom I'm building the database) uses Access, and I have the
reports in Access. No problem. But their client, for whom they're processing
the data, want to be able to view the data online. Hence the SharePoint
component.
In other words, the whole reason we're using SharePoint is for the client to
be able to query their data online in a browser.
One option I thought of, if true temp tables aren't available, is to have
reporting tables, same as the local Access tables, but use a unique ID for
each report. Then, instead of the report needing exclusive access to the
table, it would only need the records with that unique ID. Then, when the
report is done, the records with that ID can be deleted.
Of course, that would cause serious table bloating over time. But I assume
that there would be some kind of compacting done on the server side as part
of routine maintenance?
That's the only solution I can think of. Surely there must be a method that
people use to build reports with.....
Thanks!
"Albert D. Kallal" <
PleaseNOS...@msn.com> wrote in message
news:kXJmr.14976$DB1....@newsfe03.iad...