Results 1 to 4 of 4

Thread: Design Choices

  1. #1
    Join Date
    Mar 2002
    Posts
    192

    Unanswered: Design Choices

    I have 20-30 action queries which will be executed nightly. Is it better to place them in a DTS package and call the package, or place them in a stored procedure and call the stored procedure?

  2. #2
    Join Date
    Sep 2002
    Location
    MI
    Posts
    19

    Access is insecure

    If you are using a Access dtabase on a web site and using an inc file for your data connections I can down load the database and crack security. As for the performance of Acess it sucks over 1,000,000,000 records.
    Jon Nelson

  3. #3
    Join Date
    Mar 2002
    Posts
    192
    This is for a SQL Server database. I'm not looking for your opinion on Access

  4. #4
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    depends on what your action queries do. If you need to move data then DTS is the way to go. If you need to work with data inside SQL server then I would faver stored procedures.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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