Post reply

Tool to generate stored procedures and class modules

  • February 12, 2004 at 2:52 pm

    #359109

    I have a sql server database and an access 2003 adp project for the client application. Is there any tool that will create select, update, insert and delete stored procedures for the tables in the database and then also create the wrapper classes to utilize the stored procedures in the access adp application?

    Thanks much for any help.

  • February 12, 2004 at 9:50 pm

    #493936

    I use Dev Wizard http://www.q-d.com/dw.htm. Design your tables and it'll write your procs, vb com props and methods and even the asp forms.

    Dave

    Trainmark.com IT Training B2B Marketplace
    (Jobs for IT Instructors)

  • February 13, 2004 at 1:53 am

    #493956

    You could find something useful here:

    http://www.codegeneration.net/

     

    /rockmoose


    You must unlearn what You have learnt

  • February 13, 2004 at 3:12 am

    #493962

    Look at http://qa.sqlservercentral.com/products/

    Mirek

  • February 13, 2004 at 4:21 am

    #493968

    If you code in VB or VB.Net, you should take a look at http://www.vbexpress.com. I've used their VB6 product for two years now and it's a real time-saver.

  • February 16, 2004 at 4:09 pm

    #494281

    Why don,t you link the tables in the access and the SQL database. Ensure the security on the SQL server. Create a DSN with that security and select a 10 column unique key.

    I have used this process a lot and it is being used in the corporate envirounment with success.

    In this case the user from the MS Access will not be able to modify the table structure but whenever anything gets updated in the MS Access the same gets updated to SQL and visa versa.

    Another advantage that you can get from this process is that if you want some other tables to be updated based on the value in linked table you can write triggers.

    You will require to have only SQL SP

     

    Thanks

     

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply