Tool to generate stored procedures and class modules

Question

Tool to generate stored procedures and class modules

ssclmm

SSC Rookie

Points: 35
More actions
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.

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

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

chisholmd SSCrazy Points: 2490 More actions · Answer 1

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)

rockmoose SSCarpal Tunnel Points: 4601 More actions · Answer 2

You could find something useful here:

http://www.codegeneration.net/

/rockmoose

You must unlearn what You have learnt

Tschernoster SSC Rookie Points: 32 More actions · Answer 3

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

Mirek

Ursula Newbie Points: 9 More actions · Answer 4

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.

YOGIG SSC Enthusiast Points: 174 More actions · Answer 5

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