getting ms access queries to do more

Results 1 to 2 of 2

Thread: getting ms access queries to do more

  1. #1
    daniel prager Guest

    Default getting ms access queries to do more

    hi all-<BR><BR>i&#039m using ASP/ADO to create a web interface for a survey whose results are stored in a ms access database. the database has about 30 tables with 72 records and scores of fields per table. i am trying to devise a query in access to look at a table which stores dates (in 1/1/00 12:00:00 P.M. format) and select many fields for each record, analyze these fields and write to another field in a different table. i could take extract all these fields using ADO, use VBScript to analyze and then use ADO again to update the tables. but that&#039s _extremely slow_ and i believe that this can be done in access. i know how to get aggregate information for many records and one field (using the DCount,DSum etc. functions) but not many fields and one record. <BR><BR>perhaps an update query could be used? <BR><BR>any help would be greatly appreciated,<BR>thanks,<BR>daniel<BR>dlprager@stud

  2. #2
    Rob Guest

    Default RE: getting ms access queries to do more

    &nbsp;<BR>Stop using MS Access. I can see this project out growing<BR>MS Access fast. Plus MS Access is slower.<BR><BR>Miscrosoft access does have a way through the QUERY view in MS Access to establish queries that mimic SQL stored procedures.<BR>But I am not sure how. I do not use acccess.<BR>I know some people were talking about it on this list in the last month.<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts